Conditional Formating by word(s)

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
 
B

Billy Liddel

Use a formula

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

HTH
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with MS Word paragraph and character styles: format getting messed up 2
Automatically change the text format the cell when use a specific text 10
Conditional Formatting with VBA 4
recognizing conditional formatting with VBA 3
Conditional Format 2
Counting Colored Cells that are Conditional Formated 3
Conditional Formats 2
How to change the color of a cell using conditional formatting? 1

Top