ExcelBanter - Locate duplicates in a work book by using conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Locate duplicates in a work book by using conditional formatting (https://www.excelbanter.com/excel-worksheet-functions/102872-locate-duplicates-work-book-using-conditional-formatting.html)

Pchris

Locate duplicates in a work book by using conditional formatting

When new list of names are added into worksheets in the work book, need to
display if the name appears in previous sheets and how often

All times are GMT +1. The time now is 07:57 PM.