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?