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

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

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

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

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

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

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

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

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

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

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

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 -