Conditional Formatting using dates

Topper - Jun 30, 2011 at 08:13 AM
 Ant - May 17, 2012 at 09:47 PM
Hello, I have a training spreadsheet which I enter the date someone has undergone training. I want a red, amber, green system to alert me when training is next due. Each training is segregated into quarters. If someone attends training on 01/01/10 and this is entered in a cell I would like this cell to be coloured green.

Their next training would be due in the first quarter of 2011, therefore by 31/03/11. Once 01/01/11 was reached their cell containing 01/01/10 should turn amber, once 01/04/11 was reached their cell containing 01/01/10 should turn red.

2 replies

I managed to work it out with lots of help from various places. If anyone's interested in the solution just reply.
Can you pass the information to me?
Registration date
Wednesday February 9, 2011
Last seen
May 30, 2012

Jul 1, 2011 at 02:59 AM
I am interested, please share your solution to Email Id removed for security. Thanks.