Office Settings & Configuration

How to Fix Excel Formula References Not Showing in Different Colors

Maira MehtabMaira Mehtab Nov 10, 2026 869 views

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.

How to Fix Excel Formula References Not Showing in Different Colors
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.
Before you start

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.

Solution 1

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.

1
Select the formula cell

Click on the specific cell that contains the formula you want to inspect.

2
Activate edit mode

Press the F2 key on your keyboard, or click directly inside the formula bar located at the top of the worksheet.

3
Verify the colors

Look at the formula to see if the references and corresponding cell outlines now appear in different colors.

Reliable Formula Editing

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. 1. Open your file in WPS: Launch WPS Spreadsheet and open the workbook containing your formulas.
  2. 2. Enter formula edit mode: Double-click the target cell, or select it and press the F2 key on your keyboard.
  3. 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. 4. Adjust ranges intuitively: Click and drag the colored borders to easily modify the data ranges for your formula.
Vibrant, native color-coded formula syntax highlightingSeamless compatibility with Microsoft Excel (.xlsx) formulas and formatsLightweight design that rarely requires complex software repairsFree to use with a familiar, easy-to-navigate interface
microsoft office alternative - wps office

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.