I want to highlight dublicates in lists in 4 diffrent sheets in a workbook. I want all 4 sheets to be compared with each other for dublicates. Please note that dublicates are only between 2 sheets only and not more. I would prefer when a dublicate is spotted next to that cell to write "Same as sheet (the name of sheet spotted)". If it's feasible I would like a dublicate between two specific sheets to be highlighted with specific color and other color for other two specific sheets. For example all dublicates between sheet 1 and sheet 2 to be highlighted with green and dublicates between sheet 2 and sheet 3 with yellow.
On another note i would prefer if i could define the number of sheets and the names of the sheets for future workbook if it has more than 4 sheets.