Formatting Issues

Fix Conditional Formatting Cell Colors in Excel

Elise WilliamsElise Williams Nov 22, 2026 868 views

Question details

The user needs Excel to apply the newly selected fill color in a conditional formatting rule.

Fix Conditional Formatting Cell Colors in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user changes the fill color for an Excel conditional formatting rule.
Observed behavior
Excel often retains the default conditional formatting color. Some replacement colors work, but most do not.
Before you start

Identify the affected cells and the conditions that should trigger the rule. If you need help diagnosing the issue, prepare screenshots of the rule settings and sample data without private information.

Solution 1Recommended

Check the Conditional Formatting Rule and Test a New Workbook

Verify the selected fill color and rule settings, then determine whether the behavior is limited to one workbook.

1
Open the rules

Select the affected cells, then go to Home > Conditional Formatting > Manage Rules. Choose This Worksheet from the rule display list if needed.

2
Check the fill color

Select the rule and choose Edit Rule > Format > Fill. Select the desired color, click OK, and confirm that the rule preview shows the new fill before clicking OK or Apply.

3
Check the range and rule order

In Manage Rules, verify that Applies to includes the intended cells. Check for overlapping rules and use the arrow buttons or Stop If True setting where appropriate to prevent another rule from taking precedence.

4
Test a new workbook

Open File > New, enter sample data, and create a conditional formatting rule with the same fill color. Compare the result with the original workbook.

Check the Conditional Formatting Rule and Test a New Workbook
If the color still does not apply: Capture the rule settings and sample data without private information. Note whether the issue occurs in the new workbook as well as the original.
Free Microsoft Office alternative

Try Conditional Formatting in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and work with conditional formatting in WPS Spreadsheets when you want an alternative to Excel.

Apply conditional formatting rules and cell colors in spreadsheetsOpen and edit Microsoft Excel formats, including XLSX and XLSUse a familiar interface for an easier move from ExcelWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a different color from the one I selected?

Another conditional formatting rule may overlap the same cells. Go to Home > Conditional Formatting > Manage Rules, check the Applies to ranges and rule order, and inspect the fill selected under Edit Rule > Format > Fill.

How can I tell whether the problem affects just one workbook?

Create a workbook through File > New, enter sample data, and apply a conditional formatting rule using the same color. If the new workbook works, inspect the rules and ranges in the original workbook.

Where do I update Excel?

In Excel, go to File > Account > Update Options > Update Now. If that option is missing, your organization may manage updates; contact its Office administrator.

What should I share if the color still will not change?

Share screenshots of the conditional formatting rule, including its fill and Applies to range, along with sample data that contains no private information. Also report whether the issue occurs in a new workbook.