Conditional Formating by word(s)

[Michaelcip]

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

 

[Billy Liddel]

Use a formula

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

HTH
Peter

 

[Michaelcip]

Thanks much!!!!

Use a formula

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

HTH
Peter