Excel Macro

cm - Mar 10, 2016 at 11:36 AM
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