Conditioning Formatting Help

[georgiaaamayyy]

I am in need of some help - I have made a few new rules up under conditional formatting so when a date is entered it goes amber 3 days before the date and red on the date within the column F. I would like a rule so when I enter a date in column H (date returned) column F will revert back to no fill. Thank you in advance!

The rules I have set already in order are -

Formula: =ISBLANK(F1)=TRUE Format - no fill applies to - Sheet1!$F:$F stop if true - ticked
Cell Value < NOW() Format - red applies to - Sheet1!$F:$F stop if true - unticked
Cell Value < NOW()+3 Format - amber applies to - Sheet1!$F:$F stop if true - unticked

[davsth]

editing your first condition =or(isblank(f1),h1<>"") should suffice as long as stop if true is ticked


Note now() returns a date time value, today() returns jus the date. But if your formats work as you want that's fine

[georgiaaamayyy]

Thank you so much it has worked perfectly!

[georgiaaamayyy]

Just a quick question, I have been asked to make the cell F1 go green once I input information in cell H1 do you know the formula for this?

[davsth]

=H1<>""

or
H1>0