Conditional Formatting based on whether another cell is blank

Question

I have set up conditional formatting for COLUMN E, to have the font turn red when the date is past TODAY's date. What i need help with now is to ignore that formatting when the user enters a date into Column F.

I have the opposite effect right now with =IF(F3<>"",E3<TODAY())

It turns red WHEN the user enters a date into column F, when I want the opposite to take place.

logaraj sekar · Answer

Hi&nbsp;Deleted,&nbsp;Try this&nbsp;=AND(E3&lt;TODAY(),F3="")

sergeibaklan · Answer

Better absolute references for columns, otherwise dates in F also could be in red&nbsp;=($E3&gt;TODAY())*($F3&lt;1)

deleted · Answer

Thank you so much for your help!&nbsp;

deleted · Answer

THANKS!

Forum Discussion

Conditional Formatting based on whether another cell is blank

4 Replies

Resources