I am trying to get a cell to display the refresh date for retesting....
Example
Test 1 ----- Test date 15/10/02 ------ Retest Date ---- 15/10/05
I have the first 2 bits and need a formula to calculate the additional 3 years for the retest date...this is now sorted
i then need this to be formatted to change colour from a green cell to red colour 3 months before the test date, so in this case on the 15/7/05 the cell would change to Red.
i assume this could be done via conditional formatting, but need some help please.
I can not get the conditional formatting to work as i want...
so to clarify if the date is greater than 3 months prior to the retest date is should turn red, if the retest date is more than 3 months away it should be green.
please help
Andy
Also posted at:
http://www.ozgrid.com/forum/showthread.php?t=42127
Example
Test 1 ----- Test date 15/10/02 ------ Retest Date ---- 15/10/05
I have the first 2 bits and need a formula to calculate the additional 3 years for the retest date...this is now sorted
i then need this to be formatted to change colour from a green cell to red colour 3 months before the test date, so in this case on the 15/7/05 the cell would change to Red.
i assume this could be done via conditional formatting, but need some help please.
I can not get the conditional formatting to work as i want...
so to clarify if the date is greater than 3 months prior to the retest date is should turn red, if the retest date is more than 3 months away it should be green.
please help
Andy
Training Matrix.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | Name | Date of Last Course | Type of Truck | Date of Retest | ||||||||
3 | Chimp | 15-Jun-04 | 15/06/2007 | |||||||||
4 | Monkey | 15-Jun-02 | 15/06/2005 | |||||||||
5 | ||||||||||||
6 | ||||||||||||
Fork Lift |
Also posted at:
http://www.ozgrid.com/forum/showthread.php?t=42127