Highlighting Duplicates in Multiple Columns and Worksheets using Conditional Formatting

noiseboy23

New Member
Joined
Mar 29, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. MacOS
Hello All,

I am trying to highlight duplicates that can appear over a range of cells in multiple columns, in multiple worksheets. So far, have been successful in doing so on a single sheet, but I am now stuck as to making this work to the next sheet.

the Ranges this is applied to are D4:H259,J4:J259
=COUNTIF(!$D$4:$K$259,INDIRECT(ADDRESS(ROW(),COLUMN(),)))>1

this seems to work ignoring the I and K Columns, that contain other data that needs to be omitted from THIS condition.

Any help would be greatly appreciated.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

noiseboy23

New Member
Joined
Mar 29, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. MacOS
Further to my last post. I have noticed that this is not 100% correct. I have discovered that if there is a match in Column I or K, the match in Columns D-H and J will highlight, but I or K will remain unhighlighted...
 

Watch MrExcel Video

Forum statistics

Threads
1,119,223
Messages
5,576,828
Members
412,748
Latest member
MikeyP14
Top