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

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...

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

Format/ Conditional Formatting/ Formula Is
=$A1="a) value"
Choose green format

Add
Similarly for red.
--
David Biddulph

"Nevermind" wrote in message
...
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...