HI hope this explains itself better than I did in the past.
Book1.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | 11-October-02 | 28-Jun-02 | condition:dateinb1lessthan5monthsoftodaysdate=green | ||||||||
2 | 1-May-02 | condition:dateinb1=5to6monthspastoftodaysdate=yellow | |||||||||
3 | 22-Mar-02 | condition:dateinb1morethanor=6monthsoftodaysdate=red | |||||||||
4 | condition:ifnodatecellstayswhite | ||||||||||
5 | |||||||||||
Sheet1 |