conditional formatting date
 

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!

conditional formatting date
 

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

--
Regards,

Peo Sjoblom

(No private emails please)


"shane561" wrote in message
...
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!

conditional formatting date
 

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

http://tinyurl.com/ddxv4


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"shane561" wrote in message
...
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!