So are you saying that you want to test, say, D5:R5 across all 10 sheets, and highlight the cell that contains the duplicate.

Then do the same for D13:R13?
Are you only looking for dups in that specific range, or across all ranges?