Good marning FDibbins, and thank you. I tried the rules you used and not sure that's what I'm after Question; What cells did you format in the rule's you provided?

Also the only column I need to turn red or yellow is column B. So if it is 6 months from the date in column c, turn column B red and if it's 1 year from the date in column C then turn column B yellow if column B has less than 60.

I think I may have confused you in my last post, so hopefully this makes a little more sence than my previous post did. Thnak you.