change text colour
Dave Peterson wrote:
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 ??
Thanks for you help again !!!
|