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
|