Highlighting duplicate entries

  • Thread starter Thread starter Aaron Chandler
  • Start date Start date
A

Aaron Chandler

I'm trying to highlight duplicate entries in a column. Right now, I'm using
the formula found at http://www.cpearson.com/excel/duplicat.htm, which works
as follows:

My column has a column name in the first row (set to PartID). What I'm doing
is highlighting the entire column, selecting Conditional Formatting, and
using the equation =IF(COUNTIF(PartID, A2)>1,TRUE,FALSE) as the formula. A2
is the first cell that has data, the formatting is set to bold red, and all
cells are set to General formatting. I've tried doing it numerous ways -
I've tried highlighting all data cells but the column header, all data cells
including the header, clicking on the A to highlight the whole
column...nothing works. Does anyone know what I'm doing wrong?

Here's a sample of what my datasheet looks like:

PartID
2704-0001-PU
2702-0001-PU
2702-0002-PU
2702-0003-PU
650-402-11-S
650-402-11-M
650-402-11-L


Thanks,
Aaron
 
Hi
Excel doe not know what your column name PartId represents. Try the
following formula instead:
=COUNTIF($A$2:$A$1000, A2)>1
 
Back
Top