How to Fix Excel Formula References Not Showing in Different Colors
Question details
The user is unable to see different colors for formula references in Excel and wants to know how to restore or retain this color-coding functionality.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Editing formulas in an Excel workbook and trying to visually track referenced cells.
- Observed behavior
- Formula reference outlines and text tokens remain uniformly black instead of displaying different colors, and completed formulas do not retain formatting colors.
Keep in mind that Excel is designed to display colored reference outlines and tokens only while a formula is actively being edited, not after the formula is completed.
Enter Edit Mode to View Formula Colors
Confirm that Excel is currently in edit mode, as cell reference colors are only visible during active editing.
Click on the specific cell that contains the formula you want to inspect.
Press the F2 key on your keyboard, or click directly inside the formula bar located at the top of the worksheet.
Look at the formula to see if the references and corresponding cell outlines now appear in different colors.
Check Windows Contrast and Accessibility Settings
Ensure that system-level accessibility settings are not overriding Excel's default color display.
Repair Microsoft 365 from Installed Apps
If the issue persists across all workbooks during edit mode, repairing the Microsoft 365 installation can fix corrupted program files.
View and Edit Color-Coded Formulas in WPS Spreadsheet
WPS Spreadsheet provides stable and intuitive formula editing. You can easily track your referenced cells with vibrant, distinct color-coded outlines without dealing with display glitches.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open the workbook containing your formulas.
- 2. Enter formula edit mode: Double-click the target cell, or select it and press the F2 key on your keyboard.
- 3. View the color-coded references: Observe the clearly colored cell references within the formula bar and the matching colored outlines around the referenced cells in the sheet.
- 4. Adjust ranges intuitively: Click and drag the colored borders to easily modify the data ranges for your formula.

Frequently Asked Questions
Why do formula colors disappear after I press Enter in Excel?
Excel only displays formula color-coding during active editing to maintain a clean appearance on the final spreadsheet.
Is there a setting to make Excel formula colors permanent?
No, there is no supported feature in Microsoft Excel that permanently retains cell reference colors after you finish editing the formula.
Can Windows settings affect how Excel colors formulas?
Yes, enabling Windows High Contrast themes or adjusting specific accessibility settings can override Excel's standard formatting, causing references to appear uniformly black.
Will repairing Microsoft 365 delete my Excel files?
No, performing a repair from the Windows Installed apps menu only fixes corrupted software files and does not modify or delete your saved workbooks.





