Formatting Issues

How to Fix Excel Losing Multiple Font Colors Inside a Cell

John Wilson Oct 22, 2026 868 views

Question details

The user is experiencing an issue where different font colors applied to individual characters within a single text cell are lost after editing or recalculating the cell.

How to Fix Excel Losing Multiple Font Colors Inside a Cell

Product: Microsoft Excel
Device & OS: not provided
Scenario: Editing, updating, or recalculating cells that contain multi-colored text in Microsoft 365 environments.
Observed behavior: Rich-text formatting within the cell disappears, causing the multi-colored text to revert to a single default font color.

Before you start

Before applying multiple colors to text in a single cell, verify that the cell is formatted as 'Text', because Excel does not support character-level rich-text formatting for numbers, formulas, or 'General' format cells.

Solution 1Recommended

Format the Cell as Text Before Applying Colors

Setting the cell format specifically to 'Text' ensures that Excel treats the contents as a static string, which is required for preserving multiple font colors on individual characters.

Excel handles formatting differently depending on the cell type. When a cell is set to 'General', any edit might trigger a format reset if Excel attempts to auto-detect the data type. Explicitly formatting it as 'Text' stops this behavior.

Select the target cell

Click on the cell or highlight the range of cells where you plan to use multiple font colors.

Change format to Text

Navigate to the Home tab on the ribbon, locate the Number Format dropdown menu, and scroll down to select 'Text'.

Apply font colors to characters

Double-click the cell to enter edit mode (or press F2), use your cursor to highlight specific characters or words, and choose your desired Font Color from the Home tab.

Format the Cell as Text Before Applying Colors

Tip: Always apply the Text format before you start typing or coloring. If you change the format after coloring, the colors may still reset.

Solution 2

Use Word Tables for Reliable Color-Coded Documentation

If you are creating color-coded technical documentation and Excel keeps dropping formatting during recalculations, transitioning to a Word table is a much more stable alternative.

Solution 3

Separate Data into Multiple Columns

Bypass the intra-cell formatting limitation entirely by splitting your text across adjacent columns, allowing you to color code each column individually.

Easily Format Text in WPS Spreadsheet

Use WPS Spreadsheet to Keep Multi-Colored Text Formatting

WPS Office offers a robust Spreadsheet tool that flawlessly handles rich-text formatting within individual text cells. You can seamlessly open your existing workbooks and easily colorize specific characters without worrying about unexpected formatting loss.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet file.
2. Set cell format to Text: Right-click the cell, select 'Format Cells', navigate to the Number tab, and choose 'Text'.
3. Apply partial text colors: Double-click the cell, highlight the specific text you wish to modify, and select the Font Color icon from the Home tab.

Stable rich-text formatting for individual characters within a cell.High format compatibility with Microsoft Excel (.xlsx and .xls) files.Free, lightweight, and features a familiar UI for a seamless transition.

microsoft office alternative - wps office

Frequently Asked Questions

Can I apply multiple font colors to formula results in Excel?

No, Excel does not allow rich-text formatting (like multiple font colors) on the results of a formula. Multiple colors can only be applied to static text strings.

Why did my cell font color revert to black after pressing Enter?

This usually happens if the cell is formatted as 'General'. When you press Enter, Excel auto-evaluates the contents and can reset custom intra-cell formatting. Changing the cell format to 'Text' before coloring prevents this.

Does custom number formatting support multiple colors inside a cell?

No. While custom number formatting can change the color of the entire cell based on conditions (such as turning negative numbers red), it cannot apply different colors to separate characters within the same cell.

Is there a shortcut to highlight part of the text in a cell?

Yes, you can select the cell and press F2 to enter edit mode, then hold the Shift key while using the Left or Right Arrow keys to precisely highlight the characters you wish to change.

Document & File Issues