conditional formatting date

[Guest]

I want to use conditional formatting to highlight when a cell is 90, 180 and
360 days from todays date. I have data in two rows, consisting of room
number and date.

701 702 703 704 705
12/1/05 10/1/04 11/5/05 7/1/03 8/5/005

I want to change the color of the room number cells green for 90, yellow for
180 and red for 360 from todays date.

Thanks for any help on this!

 

[Peo Sjoblom]

http://www.contextures.com/xlCondFormat01.html

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Ragdyer]

Did you try the suggestions you received to your identical post 2 days ago?

http://tinyurl.com/ddxv4