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

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

On May 9, 1:24*pm, "Nevermind" wrote:
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...

See your post on another group (to which it didn't belong).
Please don't multipost.
--
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...

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




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

On May 9, 1:24 pm, "Nevermind" wrote:
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...

See ma answer to Pate_UK





"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
See your post on another group (to which it didn't belong).
Please don't multipost.
--
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...

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.]
--
David Biddulph

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




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

On May 9, 1:24 pm, "Nevermind" wrote:
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...

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

On May 9, 2:21*pm, "Nevermind" wrote:
I know that but this work for that one cell. But how to make a whole row
turn red?

"Pete_UK" wrote in message

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

On May 9, 1:24 pm, "Nevermind" wrote:



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...- Hide quoted text -

- Show quoted text -