Changing line colour by action

J

johncouzins

Is it possible to change the colour of a colour by formula? Say that if
box A4 has the word ok in it to change the colour of the line it’s on
to red? I haven’t used an IF command to do this before and am not even
sure if it’s possible.

Hope someone can help


Cheers


John
 
B

Bob Phillips

Yes, select the row, use condition formatting (Format>Conditional
Formatting) with a condition of Formula Is, and a formula of

=ISNUMBER(SEARCH("ok",$A4))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"johncouzins" <[email protected]>
wrote in message
news:[email protected]...
 
Top