mardi 3 octobre 2017

Excel: Conditional formatting if date is before today AND adjacent cell is empty

Let's say I have dates in cell G1:G999 and H1:H99. I am trying to establish conditional formatting for column G to highlight the cells with dates that are prior to today AND the adjacent cell in row H is empty. I was wondering if this can be done in this sort of combination.

Thanks all!

Aucun commentaire:

Enregistrer un commentaire