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.
0
Can you pass the information to me?
0
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.
0