Conditional formatting and what if function
 

I am trying to change a row of information where a conditional format is in
place. for example if cell k3 shows hello conditional format changes text to
green anf if goodbye changes test to red. what i want to do is have a3-k3
all change to respective colour of formatted cell. how do i do this?

Conditional formatting and what if function
 

Hi

Select A3:K3 and goto Conditional Formatting Condition 1: Formula is
=$K3="hello" Format as required.

Hopes this helps.
....
Per

"stumpy45" skrev i meddelelsen
...
I am trying to change a row of information where a conditional format is in
place. for example if cell k3 shows hello conditional format changes text
to
green anf if goodbye changes test to red. what i want to do is have a3-k3
all change to respective colour of formatted cell. how do i do this?

Conditional formatting and what if function
 

1. Select the cell/Range a3-k3
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=$K$3="Hello"
Click Format ButtonPattern and select your color (say Red)
4. For Condition2Select 'Formula Is' and enter the below formula
=$K$3="Goodbye"
Click Format ButtonPattern and select your color (say Red)
5. Hit OK


If this post helps click Yes
---------------
Jacob Skaria


"stumpy45" wrote:

I am trying to change a row of information where a conditional format is in
place. for example if cell k3 shows hello conditional format changes text to
green anf if goodbye changes test to red. what i want to do is have a3-k3
all change to respective colour of formatted cell. how do i do this?