Conditional Formatting using dates

Solved/Closed
Topper - 30 Jun 2011 à 08:13
 Ant - 17 May 2012 à 21:47
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.



Related:

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 9 February 2011 Status Member Last seen 30 May 2012
1 Jul 2011 à 02:59
I am interested, please share your solution to Email Id removed for security. Thanks.