No real need for the If. OR will evaluate to true or false...
--
HTH...

Jim Thomlinson


"Pranav Vaidya" wrote:

Goto Format--conditional formatting

Select 'Formula Is'

and enter this formula

=IF(OR(C29=1,C29=2),1,0)

Make suitable changes to suit your requirements

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"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!