This would work:

=Or(a1=4,A1=8,A1=13,A1=25)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"David in VB" <David in wrote in message
...
Hi, I'm surprised that I can't find this matter addressed in any user guides
since I'm sure I'm not the first person to want to do this.

Okay, I'm sure it's easy and I'll feel dumb when someone explains it: I
want to do conditional formatting for multiple, non-consecutive values.
For
instance, I want to conditionally format any cells that contain the numbers
4, 8, 13 and 25. How do I do that? Excel alwys seems to want to only
conditionally format a range or a top percentile or things that fit in
formulas.

And, once I do this, how can I make this an easy function each time?
Specifically, I receive Excel tables from time to time with mailing lists.
I
don't want to send mail to certain zip codes. So, I want to be able to
conditionally format the new excel tabls I receive against a standard list
of
zip codes I want to exclude. I guess ultimately, I'd like to make a macro.

Thanks for any help anyone can provide.