I have a spread sheet that shows dates when people have been assessed to be fit to carry out exercise I want to be able to put dates into a cell that are older than today e.g. 07.07.2013 and it turns the cell green then 11 months from that date the cell turns yellow and 12 months from date cell turns red. I can get conditional formatting to do this from the present date but not from older dates any help would be gratefully appreciated
07,. 07. 2013 = Green
07.06. 2014 =Yellow
07.07.2014 = Red