Duplicate Number Highlighting

[scarlings]

I am looking for help in writing a macro to highlight duplicate number in two separate rows. The conditional formatting is really close to what I need BUT one row will have the same number twice and is highlighting the number based on that and throwing the whole thing off. I have below a small example of what the rows look like.
I need it to highlight matching numbers from column A and column B but not be effected if the number in A is doubled.
542281 542308
542308 542416
542416 542443
542443
542281
So the macro would only highlight the numbers 542308,542416,542443 in column A.

[walruseggman]

Please Login or Register  to view this content.

[Winon]

Hi scarlings.

If you want to change Data at some point, and would like to start from Scratch, here is an approach to consider.

Add the Code below to a Click Button:

Please Login or Register  to view this content.

Use the Code below on a "Reset" Button:

Please Login or Register  to view this content.

Regards.