format cells when containing specified text

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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>
 
Back
Top