Ooops!

Yep, you're right. No array constants.

Biff

"Dave Peterson" wrote in message
...
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