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!
|