Use conditional formatting with a formula in one column of say
=COUNTIF(H:H,A1)0, and in the other =COUNTIF(A:A,H1)0, and a suitable
pattern colour. All duplicates in either column will then be highlighted.

--
HTH

Bob Phillips

"Debi" wrote in message
...
Is there a way with out having to physically line uo the columns to
compare
two or more columns for identifing and flagging any duplicate entrires of
ethier text or numbers