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!

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!

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!