Conditional Formatting error
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?
|