Hi

Hoping for a bit of help on what I assume is quite simple but I just can't sem to figure out how to implement.

I have a column of dates, and I want to use conditional format according to the date shown.

If date is older than today = red
If date is within 6 months of today = yellow
If date is over 6 months from today = green

Adding multiple conditional formatting rules seems to overwrite the previous rule so I was hoping there is one formula which can capture all of the statements.

Many thanks in advanced .