Counting unique formats in a workbook

[MWS123]

I'm trying to clean up a workbook which has too many formats in it. Is there
a way of counting how many unique formats exist in each worksheet? I'd like
to know how many formats per sheet so that I can make a better decision on
which ones to clean up first.

Regards,

Mike

 

[galimi]

Excellent question (which I don't have the answer to). Here is what I would
do.

Cycle through all the sheet objects in the workbook, cycling through the
usedrange objects and inspecting the numberformat cell.