Thanks for the help
I find that if I place the suggested formula in cell A2 it follows the
status of A1. however I need to place a date into cell A2. Should I
be putting the formula into the conditional formatting area?
--
Jerry Eggleston
------------------------------------------------------------------------
Jerry Eggleston's Profile:
http://www.excelforum.com/member.php...fo&userid=9898
View this thread:
http://www.excelforum.com/showthread...hreadid=483552