Assuming your 3-digit codes are text, then try this for your Conditional
Formatting formula...

=ISNUMBER(MATCH(B1,{"044","039","108","111","125", "166","200","309","310","338","339","341","346","5 26","587","710","787","789","889","948"},0))

If they are actually numbers formatted to have leading zeroes, then try this
instead...

=ISNUMBER(MATCH(B1,{44,39,108,111,125,166,200,309, 310,338,339,341,346,526,587,710,787,789,889,948},0 ))

--
Rick (MVP - Excel)


"Oscar" wrote in message
...
Hi,

I have a column with a range of numbers. I have a total of about 600+
accounts on Column A and on Column B I have a three digit code. If any
account has the following codes
(044,039,108,111,125,166,200,309,310,338,339,341,3 46,526,587,710,787,789,889,
and 948) I would like for the cell to automaticaly flagg the cell red. How
would I enter this in conditional formating?

Thanks