Conditional format when text contains using cell reference
 

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

Conditional format when text contains using cell reference
 

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)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Cheryl" wrote:

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

Conditional format when text contains using cell reference
 

Cheryl wrote:
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


Look at the FIND worksheet function.

=FIND("a certain phrase",referenced_cell)

Conditional format when text contains using cell reference
 

John,

That worked like a charm! Thank you! :)

Cheryl



"John Bundy" wrote:

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)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Cheryl" wrote:

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

Conditional format when text contains using cell reference
 

Thanks Glenn. :)

Cheryl


"Glenn" wrote:

Cheryl wrote:
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


Look at the FIND worksheet function.

=FIND("a certain phrase",referenced_cell)