All,
I have a list of P&L numbers that belong to a sub-group called CTX. If the
EE's P&L number is part of this subgroup, I want it to be green and bold. If
these P&L numbers were in a nice little group I could use a simple "between"
but alas, that isn't the case.

I have a list and I was thinking that somehow I could use VLookup (set to
False to return only the exact matches) and if my EE's P&L matched one of the
P&L's on my list, it would turn green. I can't seem to get this to work in
either "cell value is" or "formula is" conditions

Is this even possible? Or should I string a bunch of "cell value equals
1130 OR 1170 OR 1200 OR 1210" (for about 40 numbers). At what point would
excel choke on the string?

I know a little VBA so I'm okay going in that direction but the message
about having VBA in the workbook gets very annoying (and scares my end
users). If VBA is the way to go, I'll need help to keep it clean (or
figuring out how to sign it digitally so it seems clean!)

Thanks in advance,
Alicia