conditional formatting for dates

[basil.licop]

Hi All,

I need some help with conditional formatting for dates.

Heres my criteria for conditional formatting:
1. if date is within 60 days - green color shading
2. if date > 60 days from today but < 120 days - yellow color shading
3. if date > 120 days from today - red color shading

seems simple enough but i have trouble figuring it out.. heres what i have to begin with & im sure I got it wrong.. help!

=IF(A2-TODAY()<=60,,) for #1

 

[djm67]

For A date in cell A1, use the following:

Condition1:
Formula Is:  =A1+1730 < TODAY()

Thanks