Hi,
I am trying to create a conditional format for my excel sheet office 2010, If anyone can help to set it up. I have a date in cell J1 (01-01-2014), I want that cell J1 stay green first year change to yellow after second year and change red after 3 years.
Or if there is way to change the colour of row A1:H1 to yellow when it past two year and red after 3 years.
Thanks in advance,
RR
Bookmarks