Conditional Formatting using dates

Solved/Closed
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 responses

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?
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member 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.