Highlight a cell.
Can't use array constants in CF
--
Biff
Microsoft Excel MVP
"Rick Rothstein" wrote in message
...
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
|