Hi, does anyone know if it's possible to highlight duplicates across 8 worksheets?
I will have a table of 30 ID numbers on each sheet, and I want it highlighted in colour if there are two of the same.
Basically the same function as condition formatting, but I can only get that to work on one sheet.
Bookmarks