Hello Kurian,

Have a look at this article. Unfortunately, there is no easy way to determine the number of formats you have in the workbook.

Too Many Different Cell Formats Error

Sincerely,
Leith Ross