E
ECH123
sing Excel 2007 - Trying to write a conditional formula for cells that have
either text and dates i.e
A B C D E
1. DATE MAY 09 JUN 09 JUL09 AUG09
2. 16 Feb 09
3. Complete
For B2, need formula to look at A2, if A2 = complete, then Blank, if A2 =
date then difference between B2 and A2, in this case May 09 and Feb 09, if
less than 3 months, then fill RED, if greater than 3 months but less than 6
months, then fill AMBER, IF greater than 6 months then fill GREEN.
Is this possible?
either text and dates i.e
A B C D E
1. DATE MAY 09 JUN 09 JUL09 AUG09
2. 16 Feb 09
3. Complete
For B2, need formula to look at A2, if A2 = complete, then Blank, if A2 =
date then difference between B2 and A2, in this case May 09 and Feb 09, if
less than 3 months, then fill RED, if greater than 3 months but less than 6
months, then fill AMBER, IF greater than 6 months then fill GREEN.
Is this possible?