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