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
Bookmarks