Highlight Duplicates Across Multiple Sheets
Hi, I have a workbook with 20 tabs, for simplicity sake I will name them 1 to 20. Tab 2 to 20 are data entry tabs while tab 1 is the masterlist tab where all data from tabs 2 to 20 are consolidated. how do I use the highlight duplicate conditional format to check for duplicates within and across worksheets (2 to 20)?
First, Created dynamic range name by formulas:
under the name “sht”.
Put tabs names in this Sheet named (“Admin”).
Use the below formula in conditional formatting of each Tab:
The soltion file attached: