Hi Alan,

Unfortunately, I NEED to be able to see ALL of the duplicates in their
native column, because I need to change the values in the next column. So I
don't think that would be the way to go. BTW, I DID get it to work, but
strangely enough, it is not consistent. IOW, in one instance, the col. has 5
KNOWN duplicates, but it only highlighted the last 4, or similarily, it will
highlight the first 4. And sometimes it shows an item highlighted, but there
are NO duplicates. (Fortunately, that doesn't happen alot, or I'd go crazy!)
AND, whether I used this formula =COUNTIF($D$2:$D$2566,D2333)1 or this one
=IF(COUNTIF($D$2:$D$2566,D2333)1, TRUE, FALSE) didn't make ANY difference.

What do YOU think?

"Alan" wrote:

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