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?