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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

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,118,134
Messages
5,570,364
Members
412,320
Latest member
sixnine0312
Top