Yes, one value on one row, the next on the following, and then include all 3
cells (inc. header) in the criteria.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Phil C" wrote in message
...
Hi Guys

I set up a criteria range in connection with advanced filter.
Is there an OR syntax for a criteria?
I am trying to enter "Black" OR "Purple" but no joy.
Do you have to put 2 rows in the criteria range??

Thanks for your help

Phil