Conditional Formatting

[luisitocarrion1900]

Is it possible to have a condition Formatting that six month before todays date its highlighted in Green, and stays that color till it reaches 3 months before todays date and then change color to yellow and stay yellow till it reaches 1 month before todays date and at that time it will turn red until a new date its entered.

 

[Joe4]

Let's say that your date is in cell B2. Then you could so something like this for the 3-6 span:

=AND(TODAY()-B2>90,TODAY-B2<180)

and then choose your green color.

Repeat the same logic for the others, adding in more CF rules.