due dates

  • Thread starter Thread starter canman
  • Start date Start date
C

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
 
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)
 
Back
Top