| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color rows based on date in a cell?
Programming question? Hopefully so.
Excel novice here I would like to color a row yellow at a certain date, then red at another. This is for a project and the yellow and red correspond to due dates. Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red. I would also like to color a row (some color) when a 100% is reached in the "completed %) cell. Help is appreciated! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color rows based on date in a cell?
Ignore, as this is now in General Excel forum,,
"tbo" wrote: Programming question? Hopefully so. Excel novice here I would like to color a row yellow at a certain date, then red at another. This is for a project and the yellow and red correspond to due dates. Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red. I would also like to color a row (some color) when a 100% is reached in the "completed %) cell. Help is appreciated! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color rows based on date in a cell?
Look at Conditional Formatting - this is exactly for it is for
"tbo" wrote: Programming question? Hopefully so. Excel novice here I would like to color a row yellow at a certain date, then red at another. This is for a project and the yellow and red correspond to due dates. Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red. I would also like to color a row (some color) when a 100% is reached in the "completed %) cell. Help is appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color rows based on a cell value | Excel Programming | |||
| Color cell text based on date | Excel Programming | |||
| Color cell text based on date | Excel Programming | |||
| cell color change based on due date | New Users to Excel | |||
| Change cell color based on date | Excel Programming | |||
Linear Mode
