Highlight duplicate entries
 

Hi...

Looking for a way to highlight duplicates in a column either by conditional
formatting or code. Thanks in advance

Highlight duplicate entries
 

You can do this with conditional formatting and a countif formula, something
like this...Select all of column A for example. Select Formatting -
Conditional foramtting. Change Cell Value to Formula and add this formula.
Apply your format and that should do it...

=COUNTIF(A:A, A1)1
--
HTH...

Jim Thomlinson


"Gordon" wrote:

Hi...

Looking for a way to highlight duplicates in a column either by conditional
formatting or code. Thanks in advance