Pete_UK
Fri May 09 09:13:37 CDT 2008
Select Formula Is rather than Cell Value Is and in the formula you
should use semi-absolute references, e.g. something like this:
=3D$A1=3D"red_value"
assuming that A1 is the cell with the drop down.
Hope this helps.
Pete
On May 9, 2:21=A0pm, "Nevermind" <neverm...@hotmail.com> wrote:
> I know that but this work for that one cell. But how to make a whole row
> turn red?
>
> "Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:ec795ae6-a3e4-4ba4-89de-fa059fab77d4@y38g2000hsy.googlegroups.com...
> 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" <neverm...@hotmail.com> 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 -