Use format|conditional formatting
formula is:
=isnumber(search("somestring",a1))

=find() is case sensitive
=search() isn't

Or

formula is:
=countif(a1,"*somestring*")0
(you don't even need that 0 portion)

Jeff wrote:

can you use conditional formatting to change the color of text within a
cell if it contains specific text ?? or is there an easy macro to do same ??

--

Dave Peterson