I have 2 cells (A1 and A2). I would like to have the following take
place.
1. If I place a date that is either past or withinthe next 30 days
into A2 format the text as red.
2. If I place any date into cell A1, I need A2 to say N/A.
I have been able to do #1 using conditional formating but am stuck on
#2.
Can anyone help?
Thanks
--
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