Highlight duplicate row values

**Brian Tam** · 08-27-2010, 04:32 PM

I have a table that has about 5000 rows and I would like to highlight duplicate cell values in there respective row. I'm not sure how to accomplish this. I have been playing around with no results.

Any help would be greatly appreciated.

**zbor** · 08-27-2010, 04:35 PM

Select your data

In conditional formatting -> New rule -> Use a formula to determine which cells to format

write =COUNTIF(a:a,a1)>1 and use desired formatting

**Brian Tam** · 08-27-2010, 04:39 PM

Thank you for the quick reply.

I forgot to say that the values are alphanumeric.

**oldchippy** · 08-27-2010, 04:40 PM

Hi,

In xl2007 CF > Highlight Cells rules > Duplicate Values

**zbor** · 08-27-2010, 04:40 PM

Doesn't matter

**Brian Tam** · 08-27-2010, 04:54 PM

Thanks again for the quick reply.

For some reason it's not getting the results I would like.

I uploaded a file of what I was hoping it would look like.

Thanks for the help.