Forum Discussion
Conditional Formatting based on whether another cell is blank
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 int...
Hi Deleted,
Try this
=AND(E3<TODAY(),F3="")
Better absolute references for columns, otherwise dates in F also could be in red
=($E3>TODAY())*($F3<1)