How many Custom Formats can Excel hold before crashing

[bearcub]

Is there a limit as to how many custom formats Excel can contain? I read somewhere it might be 64,000 (based upon a workbook with 100 sheets or so). Is there a limit to how many custom formats (i.e. fonts, typeface fill, alignment, numeric, borders, conditional formatting) that Excel can hold before it crashes?

Thank you for your help,

Michael

 

[ISY]

Hi,

[FONT=&quot]Unique cell formats/cell styles is[/FONT] 64000

https://support.office.com/en-us/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3
https://excel.tips.net/T002133_No_More_Custom_Formats_Can_Be_Added.html

 

[bearcub]

Thank you this is great information!

Michael