change text colour

J

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 ??
 
D

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)
 
L

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).
 
J

Jeff

Dave said:
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)
Click to expand...
Thanks for you help again !!!
 
Top