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...
David Biddulph - 09 May 2008 13:44 GMT
Format/ Conditional Formatting/ Formula Is
=$A1="a) value"
Choose green format
Add>>
Similarly for red.

Signature
David Biddulph
> In a row I have a one cell which is drop down list so I can choose a) or
> b) value.
[quoted text clipped - 3 lines]
>
> Thanks...