MACROS

Have two columns of data that are ASIN numbers. I need to paste the ASINs into the two columns and be able to run a macro that will do a look up on column one ASIN to see if it is duplicated in the in the second column and if it is needs to alarm and turn ASIN red.