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