I'm looking for the correct formulas for the following:
Cell contains a date. Cell must be: colour red up to date entered in cell, colour yellow from date +7 days, colour green from +8 days onwards from date entered in cell.
I understand it involved rules for conditional formatting but the formulas used don't seem to be working.
Thanks very much.
Bookmarks