Conditional format when text contains using cell reference

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
 
J

John Bundy

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)
 
G

Glenn

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

Excel does not accept text format! 0
Conditional Formatting Formula 3
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
External cell reference between two excel worksheets both in One Drive 0
Conditional fomatting for cells containing a Comment 9
countifs Function not giving desired result with date criteria 2
Change the colour of a cell if another named cell is blank 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top