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)