VBA code to highlight duplicates - all in the same colour across workbook

[dslhs]

Hi,

I'm basically looking for a VBA that-
- identifies duplicates across the whole workbook/multiple sheets
- highlights duplicate cells to same random colour (preferably a light colour so text is still visible)
- ignores blank cells

Any ideas?

Many thanks,

 

[davesexcel]

You may have to provide additional information, Highlight duplicates in multiple sheets is not very clear.

 

[dslhs]

There are multiple columns of names on each sheet. Each name is a different cell. I'd like to find a way of highlighting names that appear across multiple columns, but not just in one sheet, but the whole workbook (other sheets have multiple columns of names in them).

Thanks!