Conditional Formating by word(s)
 

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

Conditional Formating by word(s)
 

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

Conditional Formating by word(s)
 

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