Conditional Formating by word(s)

  • Thread starter Thread starter Michaelcip
  • Start date Start date
M

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
 
Use a formula

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

HTH
Peter
 
Back
Top