Highlighting Duplicates in Multiple Columns and Worksheets using Conditional Formatting

[noiseboy23]

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.

 

[noiseboy23]

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...