do you know how to....

[dan s]

Is there a way to use Excel to help identify like numbers
from two differnt lists of numbers. These lists of
numbers contain numbers that are numeric and alpha-
numeric.

 

[Bob Phillips]

With conditional formatting and a formula,

Say list 1 is in A1:A1000, list 2 in H1:H5000

Select A1:A1000, and add a CF formula of =COUNTIF($H$1:$H$5000,A1)>0

and then H1:H5000, and add a CF formula of =COUNTIF($A$1:$A$1000,H1)>0=

--

HTH

RP
(remove nothere from the email address if mailing direct)