I tried

=NOT(ISNA(MATCH(M3, {1,2,3,4,5,95,96,97,98,99},FALSE )))

and got the following error:

You may not use unions, intersections, or array constants for Conditional
Formatting criteria.

I'm trying some of the other suggestions as well.

Thank you for your help.

"Jim Thomlinson" wrote:

Conditional format the cell using formula is and then you wnat samething
like...
=NOT(ISNA(MATCH(A1, {1,2,3,4,5,6,7,8,9,95,96,97,98,99},FALSE )))

That formula checks the value of cell A1 against the numbers indicated.
--
HTH...

Jim Thomlinson


"Ash" wrote:

Is it possible to use conditional formatting for more than one set value?

For example, if a cell has a value of either 01,02,03,04,05,96,97,98, or 99,
I want to highlight the cell. I've searched the help function and the
website and don't see anything that specifically addresses this question.

Any help is greatly appreciated!