Conditional formatting and what if function

[stumpy45]

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?

 

[Per Jessen]

Hi

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

Hopes this helps.
....
Per

 

[Jacob Skaria]

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


If this post helps click Yes