Hi,

I don't know what you mean by "as you copy down the column". I am using the
"Conditional Formatting" tool/dialog, which is covered on the web page. Am I
supposed to "copy down the column" instead?

"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