Conditional format when text contains using cell reference

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Hi All,
I'm trying to format a cell based on the text content of another cell. The
part I'm having problems with is that the referenced cell will "contain" a
certain phrase I'm looking for. Any ideas?

Thanks.
Cheryl
 
Depending on how flexible you need the 'Contains' to be, you can go to
conditional format, select formula is and enter something like:
=FIND("dog",$B$1), if "dog" is found anywhere within it will turn red. (after
you set it to turn red of course)
 
Cheryl said:
Hi All,
I'm trying to format a cell based on the text content of another cell. The
part I'm having problems with is that the referenced cell will "contain" a
certain phrase I'm looking for. Any ideas?

Thanks.
Cheryl
Click to expand...


Look at the FIND worksheet function.

=FIND("a certain phrase",referenced_cell)
 

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

Comparison of columns using Conditional Formatting 3
Conditional fomatting for cells containing a Comment 7
Conditional format cell containing hyperlink 2
Conditional formatting a cell containing "<" 4
Conditional Formatting Based on Cell Content 3
Excel VBA 1
conditional formatting update issue 5
Conditional Formatting 4th Condition 3

Back
Top