change text colour

[Jeff]

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]

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)

 

[Lena]

Yes, you can use conditional formatting. Select the row(s) where you need to
use formatting, then go to Format-Conditional Formatting. In Condition select
Cell value is Equal To and type the text you need (or select the cell that
contains needed text). Then click Format button and select text color you
need (or other formatting options).

 

[Jeff]

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)

Thanks for you help again !!!