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
|