Forum Discussion

Aaron Lockett's avatar
Aaron Lockett
Brass Contributor
Nov 02, 2018

Help with Conditional formatting

I'm Trying to get the dates in Column H to turn red if the current date has surpassed the required date stated in Column H and no date has been entered in Column I. Once a Date is entered into Column I, Column H should turn back to black.

Attached is an example to show the conditional format formulas currently being used.

  • Hi Aaron,

     

    You may modify you "red" rule formula as

    =(H1-TODAY()<1)*ISBLANK(I1)

     

Resources