Hi!

Try this:

Assume the range in question is A1:A10

Select the range A1:A10
Goto FormatConditional Formatting
Formula is: =COUNTIF(A$1:A1,A1)1
Click the Format button
Select the style(s) desired
OK out

Biff

"mj" wrote in message
oups.com...
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