Excel shows "Too many different cells formats"

[Guest]

When I try to change a cell's color, Excel 2002 often
show me a message box "Too many different cells formats",
and the content of the cell is deleted.

Could you solve my problem

Thank you

 

[Simon Murphy]

Excel can only hold around 4000 different formats and that
includes all the elements of format.

see details and suggestions here:

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

I've seen this problem where people from different
countries have worked on a file. the solution is to
reduce the formatting combinations. Use 1 or 2 fonts use
3 or 4 sizes, just a couple of colours etc.

cheers
simon