Hello, I have 2003, I'm trying to color cells that have specific words w/in
the cell. I want to count words like "*broke*" and "broken*" as the same to
get the same formating. I need to do this for 6 other words to be formatted
in their own unique color. Surprised that I couldn't find any info. in these
discussion groups that spoke of my dillema. Thanks much, MC

Use a formula

=ISNUMBER(SEARCH("broke",B19)) where B19 is the start of the selection.

HTH
Peter

"Michaelcip" wrote:

> Hello, I have 2003, I'm trying to color cells that have specific words w/in
> the cell. I want to count words like "*broke*" and "broken*" as the same to
> get the same formating. I need to do this for 6 other words to be formatted
> in their own unique color. Surprised that I couldn't find any info. in these
> discussion groups that spoke of my dillema. Thanks much, MC

Thanks much!!!!

"Billy Liddel" wrote:

> Use a formula
>
> =ISNUMBER(SEARCH("broke",B19)) where B19 is the start of the selection.
>
> HTH
> Peter
>
> "Michaelcip" wrote:
>
> > Hello, I have 2003, I'm trying to color cells that have specific words w/in
> > the cell. I want to count words like "*broke*" and "broken*" as the same to
> > get the same formating. I need to do this for 6 other words to be formatted
> > in their own unique color. Surprised that I couldn't find any info. in these
> > discussion groups that spoke of my dillema. Thanks much, MC