Color row based on cell value
 

I see several posts about conditional formatting.
As a novice what I need is a walkthrough no matter what the solution!

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 row based on cell value
 

Format/ Conditional Formatting/ Formula is
=$A1=DATE(2009,12,11)
Select your yellow format
Add
Formula is
=$A1=DATE(2009,12,19)
Select your red format
Add
Formula is
=$B1=100%
Select your appropriate colour

Adjust the references if the date is in a different column than A and if the
completed cell is in a different column than B, but notice that the address
is absolute for the column and relative for the row. Check the position of
the $ signs in the cell references.
--
David Biddulph

"tbo" wrote in message
...
I see several posts about conditional formatting.
As a novice what I need is a walkthrough no matter what the solution!

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 row based on cell value
 

This looks promising. Seems the answer lies in conditional formatting.
Must be easy when you know what you're doing. ;)

http://www.asap-utilities.com/blog/i...-a-cell-value/

"tbo" wrote:

I see several posts about conditional formatting.
As a novice what I need is a walkthrough no matter what the solution!

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!