Conditional Formatting Date Formula

[Manolocs]

I have a table with 2000 cells, all of then has dates,
any cells in this table need to show:

1-blue between 30 days before today and stay blue until today,

2-green between 60 days before today and stay green until 31 days before today, then turn blue, until today,

3-any cell with a today date and after, turn red.

 

[DonkeyOte]

highlight the range and then do conditional formatting -- setting formulas as follows

condition 1

=TODAY()-A1<=0

condition 2

=TODAY()-A1<=30

condition 3

=TODAY()-A1<=60

alter A1 to be leftmost cell in your range and obviously adjust your formats.