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)

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

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 !!!

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