Changing line colour by action

  • Thread starter Thread starter johncouzins
  • Start date Start date
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
 
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]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to change lines in graph to individual colours 0
Help with date formula and colour change 3
Cell colour change if formula displays false 3
Excel Colour code dates 1
Changing Font Colour 9
search text for substring and change text colour of substring 5
Changing colour of cell on a certain date 1
Changing Font Colour of row depending on selection made in 1st col 1

Back
Top