Hi

I am looking for a way to show if a programmed course is within the 2 year period in which it is required. I have a spreadsheet which i have formatted it to show the dates the course is required. Once the programmed date is inserted i would like it to go green if it is within the 2 year period and red if outside. I can do it for a single entry but not for full columns. I have a number of sheets to add this to, can anyone help please.

Excel 2010.

Thankssample.xlsx