Excel Performance Problems

How to Fix Excel Worksheet Colors Disappeared and Functions Not Working

Muhammad TalhaMuhammad Talha Nov 3, 2026 870 views

Question details

Excel fill and font color functions fail to apply, and all existing worksheet colors display only in black and white.

How to Fix Excel Worksheet Colors Disappeared and Functions Not Working
Product
Microsoft Excel
Device & OS
not provided
Scenario
Viewing or editing existing workbooks, or attempting to apply new color formatting to cells.
Observed behavior
Workbooks are rendered entirely in black and white, and color-related tools in the ribbon do not apply any visible changes to the spreadsheet.
Before you start

Before altering Excel's internal settings, ensure that you haven't accidentally enabled a High Contrast or specialized accessibility theme in your Windows operating system, as this will override application colors.

Solution 1Recommended

Disable Windows High Contrast Mode

High contrast settings in Windows force Office applications into a monochrome display, ignoring all applied cell colors and themes.

Microsoft Office natively integrates with Windows accessibility settings. When High Contrast mode is active, Excel suppresses its own color rendering to comply with system-wide accessibility rules, making it seem like the color functions are broken.

1
Open Windows Settings

Press the Windows Key + I on your keyboard to open the Windows Settings app.

2
Navigate to Accessibility

Click on 'Ease of Access' (in Windows 10) or 'Accessibility' (in Windows 11).

3
Turn Off High Contrast

Select 'High contrast' or 'Contrast themes' from the side menu and toggle the switch to 'Off' or select 'None' from the dropdown menu. Apply the changes and restart Excel.

Disable Windows High Contrast Mode
Instantly Restored: Disabling High Contrast mode will immediately restore all previously applied fill and font colors in your workbooks.
Free Microsoft Office alternative

Open Your Workbooks in WPS Office for Flawless Color Display

If Microsoft Excel keeps overriding your formatting with monochrome settings or encountering add-in conflicts, try WPS Office. It provides a lightweight, highly compatible alternative that renders your Excel files exactly as they were designed without unexpected display issues.

  1. 1. Download and Install: Download WPS Office for free from the official website and follow the simple installation prompts.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets, click 'Open', and select your existing .xlsx file.
  3. 3. View and Edit Colors: Your file will open with all original colors and formatting perfectly preserved, allowing you to edit without display bugs.
100% compatible with Microsoft Excel (.xlsx, .xls) formatsAccurate rendering of all cell fill colors, fonts, and themesLightweight application with no forced monochrome overridesFree to use with a familiar tabbed interface for seamless migration
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel cells suddenly lose all their fill color?

This is typically caused by accidentally enabling Windows High Contrast mode, selecting a monochrome print setting in Page Setup, or a faulty graphics driver interfering with Excel's display engine.

Do the colors still exist in the file if I send it to someone else?

Yes. If the issue is caused by your local High Contrast settings or an Excel display glitch, the actual color formatting is preserved in the file's code. Anyone opening the file on a normal device will see the colors perfectly.

How do I fix conditional formatting colors not showing up?

Go to Home > Conditional Formatting > Manage Rules to ensure your rules are still active. If they are active but invisible, check your Windows Accessibility settings or try updating your display drivers.