If you then exit the VBA editor and try to format the color of a cell, you will get the error message "Too many different cell formats." If.
Excel - Use Conditional Formatting on a Cell Based on Another Cell's Value
If you're getting the "too many cell formats" error in Excel, it means that you're trying to apply too many different formatting options to a single cell.
It *might* be due to excessive names in the workbook if you are sure all formatting is removed, including conditional formatting. Look to see how many, if any. If you want to align text, select the cells, and use the "Center across selection" horizontal format. You touched on it a little, but you might.
How do I fix too many different cell formats Excel? · Clear all spreadsheet formatting. · Use a standardized font. · Clear cell fill colors. · Clear all other cell. It usually occurs after copying large amounts of data between workbooks. The error basically locks up your workbook and doesn't let you change the format on. Message: Too many different cell formats. Solution. Please refer to the following Microsoft knowledge article regarding this issue.