Fix Conditional Formatting Cell Colors in Excel
Question details
The user needs Excel to apply the newly selected fill color in a conditional formatting rule.

- 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.
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.
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.
Select the affected cells, then go to Home > Conditional Formatting > Manage Rules. Choose This Worksheet from the rule display list if needed.
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.
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.
Open File > New, enter sample data, and create a conditional formatting rule with the same fill color. Compare the result with the original workbook.

Update and Repair Microsoft Office
Use this approach if the color issue persists, especially if it also occurs in a new workbook.
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.

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.




