due dates

[canman]

You've created a monster...
is 3 the limit to the formulas in Conditional formatting?
what if I wante next months colour to change as well :rolleyes

 

[Max]

The CF limit's 3, ..
but you could try out these revised CF formulas
(use same construct steps)

Cond 1: =MONTH(TODAY())=MONTH(F5)
Format cell fill as pale red (as before)

Cond 2: =MONTH(TODAY())+1=MONTH(F5)
Format cell fill as green? (this is for the additional next month's color)

Cond 3: =AND(TODAY()>F5,F5<>0)
Format cell fill as yellow (as before)