Forum Discussion
Highlight Duplicate values across multiple sheets
I have a spreadsheet with an exhaustive list of names (ALL NAMES). I then have several other sheets (Silver, Gold, Top, Art, Music, Latin, Key) that have the names of various award recipients (a ...
HansVogelaar When I try it gives me an error message of "You may not use references to other workbooks for Conditional Formatting criteria"
Conditional Formatting can refer to ranges on other worksheets within the same workbook, but not to ranges on worksheets in other workbooks.