View Single Post
  #3  
Old May 27th, 2010, 08:53 PM posted to microsoft.public.excel.newusers
Michaelcip
external usenet poster
 
Posts: 21
Default 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