Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) |