Can they be changed to become year sensitive???
Sorry, try the revised C.F. formulas below
for conditions 1 and 2
(condition 3 - no change)
[use same construct steps as before]
Do note that you can copy > paste* the formulas
direct into the C.F. box instead of typing ..
*Use keystrokes to paste in the C.F. box if necessary:
CTRL+V = paste
CTRL+C = copy
Cond 1:
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)=DATE(YEAR(F5),MONTH(F5),1)
Format cell fill as pale red (as before)
Cond 2:
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)=DATE(YEAR(F5),MONTH(F5),1)
Format cell fill as green (For the additional next month's color)
(No change required to condition 3)
Cond 3: =AND(TODAY()>F5,F5<>0)
Format cell fill as yellow (as before)
