Formula for Conditional Formatting Dates

Occasional Visitor

Hello, Everyone.  How do I create conditional color formatting for dates that fall in the following ranges: next 45 days (red); next 46-120 days (yellow); beyond 120 days (green); date in the past (grey)?

1 Reply



Assuming the first cell in the range you want to format is A1, try:

grey =A1<today()

green = A1-today()>120)

yellow =A1-today()>45

red =A1>today()

Also, check the box "stop if true".