software

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!
www.contextures.com/xlCondFormat01.html

--
Regards,

Peo Sjoblom

(No private emails please)quot;shane561quot; gt; wrote in message
...
gt;I want to use conditional formatting to highlight when a cell is 90, 180
gt;and
gt; 360 days from todays date. I have data in two rows, consisting of room
gt; number and date.
gt;
gt; 701 702 703 704 705
gt; 12/1/05 10/1/04 11/5/05 7/1/03 8/5/005
gt;
gt; I want to change the color of the room number cells green for 90, yellow
gt; for
gt; 180 and red for 360 from todays date.
gt;
gt; Thanks for any help on this!
gt;
gt;Did you try the suggestions you received to your identical post 2 days ago?

tinyurl.com/ddxv4--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;shane561quot; gt; wrote in message
...
gt; I want to use conditional formatting to highlight when a cell is 90, 180
and
gt; 360 days from todays date. I have data in two rows, consisting of room
gt; number and date.
gt;
gt; 701 702 703 704 705
gt; 12/1/05 10/1/04 11/5/05 7/1/03 8/5/005
gt;
gt; I want to change the color of the room number cells green for 90, yellow
for
gt; 180 and red for 360 from todays date.
gt;
gt; Thanks for any help on this!
gt;
gt;