Conditional Formatting error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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)
 
Back
Top