Excel Performance Problems

Fix Excel Freezing When Changing Font Color in One Workbook

Phi Hung VoPhi Hung Vo Nov 18, 2026 868 views

Question details

The user needs to prevent Excel from freezing when changing font color in a particular workbook.

Fix Excel Freezing When Changing Font Color in One 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the rules manager

On the VAS worksheet, select Home > Conditional Formatting > Manage Rules.

2
Display worksheet rules

In the Conditional Formatting Rules Manager, set Show formatting rules for to This Worksheet.

3
Review and remove duplicates

Compare the rules and their Applies to ranges. Select obsolete or confirmed duplicate rules and choose Delete Rule.

4
Consolidate overlapping rules

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.

5
Apply and test

Select Apply, then OK. Save the working copy and try changing the font color of multiple cells on the VAS worksheet.

Remove Duplicate Conditional Formatting Rules in Excel
Check formatting results: Removing or combining rules can change how cells look. Review the affected ranges after applying your changes.
Free Microsoft Office alternative

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.

Change cell font colors and manage spreadsheet formattingOpen and save Microsoft Excel formats such as XLSXUse a familiar spreadsheet interfaceMove existing workbooks into a lightweight office suite
microsoft office alternative - wps office

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.