Conditional Formatting renewal dates

[wrightian]

'd like to use conditional formatting to highlight each of these a different color:
Dates that are less than 179 days old in Green
Dates that are between 179 and 364 days in yellow
Dates that are 365 days or over

I have tried several answers to previous questions but whatever formaula I have tried the cells either all go one colour or no colour at all

 

[Jonmo1]

Welcome to the board...

Condition 1: Red (Over 365 days old)
=A1 < =(TODAY()-365)

Condition 2: Yellow (Between 179 and 364 days old)
=A1 < =(TODAY()-179)

Condition 3: Green (Less than 179 days old)
=A1 < TODAY()


The order of the conditions is IMPORTANT.
Because they are evaluated in order from 1 to 3.
The first to be true is executed, and the rest ignored.

Hope that helps..

 

[wrightian]

Thanks Jonmo the first 2 conditions have worked but the dates that are less than 179 days have not turned green

 

[wrightian]

Now it is working!!!! who knows