Conditional Formatting error

[Guest]

I was kindly given the following formula for checking duplicate entries in a
spreadsheet, =IF(COUNTIF(Range1, ??)>1,TRUE,FALSE)
?? being the first cell in the range to be checked, and I formatted the
duplicates to be highlighted in red.
My problem is that it only highlights 2 or 3 where there's actually 4
duplicates, or highlights none duplicates.
Help! Am I missing something?

 

[Bob Phillips]

Is ?? the cell reference? Shouldn't make any difference, but you omly need

=COUNTIF(Range1, ??)>1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)