Comparing Two Columns, Excel Not Working

Hello,

(Using Excel 2007)
Ive cross posted this forum, at this location, just to get the extra help.
http://www.mrexcel.com/forum/showthread.php?t=471883


Ive checked many websites for a solution to this, and everything Ive tried has failed.

I have a list of numbers in Column A, another list of numbers in Column B,

Im trying to find a formula or a VBA code that will take the numbers in Column A, Compare them to column B, and if a number in column A, appears somewhere in column B, I want the number in both column A, and B to be highlighted.

Example:
A | B
45 46
47 45
48 52

So for instance in this example, only the number 45 would be highlighted, because it appears in both columns.

I tried using the tool in Excel, > Conditional Formatting > Highlight Duplicates...but it seems that feature only works for comparing data in one column, I cant get that feature to look at two columns. Any help would be great. Thanks!