Quote Originally Posted by Pete_UK View Post
So a particular cell in that first range may occur in any of the other 25 ranges on that sheet, as well as in 26 ranges on 9 other sheets, and if so you want to highlight that cell?

It would help us to try to arrive at a possible solution if you attached a sample workbook - the FAQ describes how to.

Pete
Lets say a company can appear in any cell within the ranges across the 10 sheets. Each range is a reference to a week and each sheet is a reference to a staff member. What i am trying to acheive is if any staff member duplicates the name of a company within the ranges excel highlights it as a duplication.