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 G. I also have the rule that when a date is entered into column I the date in column G will go blank. Im looking instead of the I column going black to fill the cell green so at a quick glance we know this has been looked at. Please see my screen shot.Thank you in advance!
The rules I have set already in order are -
Formula:=OR(ISBLANK(G1),I1<>"") 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