Install dates formating using conditional formating?

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

Dates are just formatted numbers so there is no way of really testing for a
date except

=IF(ISNUMBER(A1),NA(),"Something else")

--

Regards,

Peo Sjoblom

"Jerry Eggleston"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>