If you are using the formula for conditional formatting, the dollar signs may
have to be removed from part of the formula to allow it to adjust as you copy
it down the column.
--
Gary''s Student


"Phil" wrote:

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