how to make cell turn red or green? Please help...

[Nevermind]

In a row I have a one cell which is drop down list so I can choose a) or b)
value.

How can I make thet if I choose a) value, whole row turn green, or when I
choose b) value, whole row turn red?

Thanks...

 

[Pete_UK]

You need to use Conditional Formatting, on the Format menu. Basically
you specify a condition and then choose the formatting you want to
apply if that condition is met.

Hope this helps.

Pete

 

[David Biddulph]

See your post on another group (to which it didn't belong).
Please don't multipost.

 

[Nevermind]

I know that but this work for that one cell. But how to make a whole row
turn red?




You need to use Conditional Formatting, on the Format menu. Basically
you specify a condition and then choose the formatting you want to
apply if that condition is met.

Hope this helps.

Pete

 

[Nevermind]

See ma answer to Pate_UK

See your post on another group (to which it didn't belong).
Please don't multipost.

 

[David Biddulph]

See my answer on the other group.
[That's why netquette tells people not to multipost. It splits the
discussion, and confuses both the questioner and those who are giving
answers.]

 

[Pete_UK]

Select Formula Is rather than Cell Value Is and in the formula you
should use semi-absolute references, e.g. something like this:

=$A1="red_value"

assuming that A1 is the cell with the drop down.

Hope this helps.

Pete