Thank you so much for getting back to me NBVC,

I have 2 working the first date and the 12 month date.

but the 6 month old date isn't working

=AND(DATEDIF(A2,TODAY(),"m")>=6,DATEDIF(A2,TODAY() ,"m")<=12)

the above formula doesn't do anything if the date is 6 months older than todays date....

Is there a way to make the colour stay in place for the full 6 months? So from today thru to 6months time it stays green. Then from 6month to 12 months its orange and then 12months old it stays red?

What am I doing wrong haha