Fix Excel Freezing When Changing Font Color in One Workbook
Question details
The user needs to prevent Excel from freezing when changing font color in a particular workbook.

- Product
- Microsoft Excel for Office 365 ProPlus
- Device & OS
- not provided
- Scenario
- On the VAS worksheet, the user selects multiple cells and changes their font color.
- Observed behavior
- Excel freezes during the font-color change. Safe Mode, graphics settings, updates, repairs, and copying content to a new workbook did not resolve the issue.
If the workbook is responsive, use File > Save As to create a working copy before changing formatting rules. Open the affected VAS worksheet and identify the cells or columns where the freeze occurs.
Remove Duplicate Conditional Formatting Rules in Excel
Use this method to check whether excessive or overlapping conditional formatting rules are contributing to the freeze.
Many duplicate rules can slow Excel or cause it to freeze when formatting cells. Preserve rule order, formulas, and Stop If True settings when consolidating rules, because these affect the results.
On the VAS worksheet, select Home > Conditional Formatting > Manage Rules.
In the Conditional Formatting Rules Manager, set Show formatting rules for to This Worksheet.
Compare the rules and their Applies to ranges. Select obsolete or confirmed duplicate rules and choose Delete Rule.
Where equivalent rules can safely be combined, select a rule and adjust its Applies to range or choose Edit Rule. Keep only the necessary formatting for the affected columns.
Select Apply, then OK. Save the working copy and try changing the font color of multiple cells on the VAS worksheet.

Edit Spreadsheet Formatting with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its support for Excel formats can make moving between office suites straightforward, although it does not repair an Excel-specific freeze.

Frequently Asked Questions
Why should I check conditional formatting if Excel freezes on one sheet?
A worksheet with many duplicate or overlapping rules can become slow when cells are formatted. On the affected sheet, open Home > Conditional Formatting > Manage Rules and display rules for This Worksheet.
Will deleting a conditional formatting rule remove my cell values?
Deleting a rule in Manage Rules removes that formatting rule, not the cell values. It can, however, change the appearance of cells covered by the rule.
How can I tell which cells a rule affects?
In Home > Conditional Formatting > Manage Rules, check the Applies to range for each rule. Compare ranges before removing or combining rules.
What if Excel still freezes after I clean up the rules?
Note the affected worksheet, selected cells, exact steps, and Excel version. Find the version under File > Account > About Excel, then provide those details when seeking further support.




