Comparing two columns for duplicates

[michaelrusk]

Hello all,

I have a quick question!

I currently have two columns.

Column A (from A2 all the way to the bottom of the worksheet)
Column B (from B2 all the way to the bottom of the worksheet)

Column A will keep a record of numbers I paste into it.

I would like to use Column B to check for any duplicates.

If there are duplicates, I would like them to show up in RED.

any ideas?

[zbor]

Try in B2: =COUNTIF($A$2:$A$65536, $A2) and pull down

A conditiona formating would be =$B2>1