View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
diaare diaare is offline
external usenet poster
 
Posts: 50
Default searching text and conditional format with multple conditions

I am using Excel 2003.

I have a very large file with lots of text. I need to search column C for 9
specific strings of text (they can be anywhere in the cell) and if any one of
these strings are there I would like to format the row a different color.

I set up conditonal formatting with this formula:
=ISNUMBER(SEARCH("vit",$C1))

and it works good. But how do add the or condtion for the other 8 strings
of text?

Thanks,
Diane