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