Excel Macro

[Closed]
Report
-
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 542281
542416 542416
542443 542443
542281

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!