| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight duplicate entries
Hi...
Looking for a way to highlight duplicates in a column either by conditional formatting or code. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight duplicate entries matching 2 criteria in another workshe | Excel Worksheet Functions | |||
| How to highlight duplicate entries? | Excel Discussion (Misc queries) | |||
| Highlight repeat entries | Excel Discussion (Misc queries) | |||
| highlight duplicate entries | Excel Discussion (Misc queries) | |||
| Highlight wrong entries in SuDoKu | Excel Programming | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
