format cells when containing specified text

G

Guest

I am trying to "conditionally format" cells different colors when they
contain certain words (e.g., if text contains 'dog' then cell color is
yellow; if text contains 'cat' then cell color is red).

I am not looking for EXACT text match before condition formatting is applied.
 
J

JE McGimpsey

One way:

Set the dropdowns and textboxes to read

CF1: Formula is =COUNTIF(A1,"*dog*")
Format1: <patterns>/<yellow>

CF2: Formula is =COUNTIF(A1,"*cat*")
Format2: <patterns>/<red>
 

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

Conditional Formatting Question 3
make all cells in same row match cell formatted with fill color 2
word match in string text in cell, color format cell 1
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous 2
How do I preserve text color when combining cell data 3
Conditional Formatting 1
Conditional Formatting 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Top