change text colour

  • Thread starter Thread starter Jeff
  • Start date Start date
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 ??
 
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)
 
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).
 
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 !!!
 
Back
Top