conditional formatting -- testing for multiple words
I have a spreadsheet with a list of products. Column D contains the
product names.
I want to format the rows to stand out if a particular word is in the
product name. I've got this to work:
=FIND("Chef",$D1)
What I'd really like to do is have the formula look for a variety of
different products; e.g., "Chef", "Apple", "Lodge" ... etc.
Is there any way to do that??
Thanks.
Barb
|