Forum Discussion

Deleted's avatar
Deleted
Jun 22, 2017

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...
Formulas & Functions
Need Help
Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Jun 22, 2017

Hi Deleted,

 

Try this

 

=AND(E3<TODAY(),F3="")
  • Deleted's avatar
    Deleted
    Jun 22, 2017
    THANKS!
  • Deleted's avatar
    Deleted
    Jun 22, 2017

    Thank you so much for your help!

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 22, 2017

    Better absolute references for columns, otherwise dates in F also could be in red

     

    =($E3>TODAY())*($F3<1)

Resources