The easiest way to do this I think is to use 'Advanced Filter', go for
'Unique Records Only' and put the filtered result in another column. This
will do what it says and remove all duplicates in the new column so you can
compare the two.
Have a look here on Debra Dalgliesh's web site, she is the expert on this
subject and gives clear tutorials on how to use it,
http://www.contextures.com/xladvfilter01.html
Regards,
Alan.
"Phil" wrote in message
...
Hello,

I have a column that has over 2,500 entries and want to simply highlight
it
with ANY duplicate entries found. I have tried this formula
=IF(COUNTIF($D$2:$D$2566, $D$2)1, TRUE, FALSE which I found on Chip
Pearson's web site (http://www.cpearson.com/excel/duplicat.htm) and it
only
highlights the first cell. I KNOW there are more than one duplicates.
The
data range begins on column D, row 2, under the col. heading.

Might there a "setting" under my "options" that I need to check on, or
something?

What am I doing wrong?

TIA for your replies.

Phil.

may have numerous en