format cells when containing specified text
 

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.

format cells when containing specified text
 

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



In article ,
dinocm wrote:

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.