CODEWITHSUNDEEP
excelexcel-formulaworksheet-functionexcel-2013conditional-formatting
Khairul
Khairul

Reputation: 301

Conditionally format cells in a column based on whether either of two cells is blank

I want to format the font color in cells of column G if both cells in column E and F of the same row are blank.

     E       F            G
-----------------------------------------    
1 (blank) (blank) (font color white)
2 xxxxxxx xxxxxxx (font color black)
3 (blank) xxxxxxx (font color black)
4 (blank) (blank) (font color white)
5 (blank) xxxxxxx (font color black)

xxxxxxx denotes that the cell is not blank.

Upvotes: 0

Views: 311

Answers (1)

pnuts
pnuts

Reputation: 59495

=AND(ISBLANK($E1),ISBLANK($F1))

should do it.

Upvotes: 2

Related Questions