How to count number of different cell formats

[emilija]

I have an excel file, which I can't opened because it has already too many
different cell formats,
which I solved by formatting, but
is there a way how can I see a statistic of the number of different formats
used in one file (out of 4000 I think), in order not to find my self in a
same situation in the future,
thanks in advance

 

[Carim]

Hi,

Take a look at

See

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904


HTH

 

[Peter T]

Unfortunately there is no direct way to count the number of unique cell
formats. In theory it's possible to devise code to do that but a lot of
work.

It is worth keeping an eye on the possibilities of excessive and unnecessary
formats, FWIW the 'too many formats' limit can be quite a lot less than the
quoted 4,000, on occasions.

Simple way is to pastespecial formats from a suitable cell over large areas
that will require similar. Delete empty unused rows and columns below and to
the right may help.

One way additional formats can creep in is after copying cells from other
workbooks. Use paste values where appropriate.

Regards,
Peter T