I entered

=OR(M3=1,M3=2,M3=3,M3=4,M3=5,M3=96,M3=97,M3=98,M3= 99)

but it didn't work. I'm in the process of trying some of the other
suggestions as well.

Thanks for your help.

"Bernard Liengme" wrote:

In the Conditional Formatting dialog
Formula Is; =OR(A1=01,A1=02,A1=03,A1=04.......,A1=98,A1=99)
Format - give cell the needed colour
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Ash" wrote in message
...
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!