Hello

I am working on a spreadsheet that lists completed training courses. Some of these courses require you to go on a refresher course every few years.

What I would like if possible is for the cells tu turn red once the course is overdue, or possibly within 1 month of being overdue, and ideally keep it on one sheet and not use another for referencing.

For example if A1 is the date the course was completed and it needs to be re-done every 3 years. Say it was completed on 1/2/13 I would like it to remain black, however once it is 2/2/2016 I would like it to turn red.

Is there a way to do this with conditional formating or an IF formula? Or would I need to recreate the spreadsheet on a 2nd sheet, list all the due dates for refreshers courses and use an IF formula to change the colour on the first sheet if it goes past that date.

I realise that the 2nd option is probably easier but I would like to make it so that you only need to change the one date so that anyone can take over the spreadsheet and I wont have to worry about them not changing all the dates and losing track of whats due when.

Many thanks

Rhys