hello all,

i just want to know what formula will i use that will highlight the
duplicated entry in a column, or shall i say, highlight the second
record that appeared in the column. I did use the conditional formating
with this formula: =countif(A:A, A1)1 but it highlights the original
and the duplicate entry. What i want is a formula that would highlight
or mark the duplicate record in the column...please help.

Thanks