Hi,

In cell A2, enter the following formula in Formats Conditional formatting
Formula is

=vlookup(A2,list2,1,0)

Choose a color for the cell. All duplicate values in list 1 will be
highlighted.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Charlotte B" <Charlotte wrote in message
...
I have two columns consisting of 1000 cells that each have 7 digits. For
example

8956743 8658237
8967842 8753689
8974389 8896536

These two columns share some of the same numbers. I want to find and LIST
all of these shared numbers. Some of these numbers are the same and some
are
different. I just need a formula to find the duplicates. HELP ME!!