Conditional formatting and what if function

  • Thread starter Thread starter stumpy45
  • Start date Start date
S

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?
 
Hi

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

Hopes this helps.
....
Per
 
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
 
Back
Top