I get an error message "Too many different cell formats"
 

When I try to change type color, format etc. Sometimes the change is accepted
anyway, and other times it isn't. It occurs in a large spreadsheet with many
formats, conditional formats and type colors. Is there a limit on format
types etc in excel.

The following MSKB article has information on the error message:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?id=213904


Bob Lindal wrote:
When I try to change type color, format etc. Sometimes the change is accepted
anyway, and other times it isn't. It occurs in a large spreadsheet with many
formats, conditional formats and type colors. Is there a limit on format
types etc in excel.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html