conditional formatting -- testing for multiple words
I don't think you can use arrays like this in conditional formatting.
Biff wrote:
Hi!
FIND is case sensitive so Chef and chef do not match.
Try this:
=OR(ISNUMBER(FIND({"Chef","Apple","Lodge"},D1)))
If you don't need it to be case sensitive replace FIND with SEARCH.
Biff
"The Moose" wrote in message
oups.com...
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
--
Dave Peterson
|