Formatting Issues

Fix Excel Cell Colors Disappearing When Copying to Word or Outlook

Muhammad Talha Oct 20, 2026 869 views

Question details

Users experience a loss of cell fill colors when pasting formatted cells from Excel to Word or Outlook.

How to Fix Excel Colors Disappearing When Copying to Outlook or Word

Product: Microsoft Excel, Word, Outlook (Microsoft 365)
Device & OS: not provided
Scenario: Copying and pasting conditionally formatted or color-filled cells from Excel into other Microsoft Office applications.
Observed behavior: Specific RGB colors, especially fully saturated ones containing the value 255 (like pure red, blue, or yellow), disappear and are pasted with a plain white fill instead.

Before you start

Verify that you are running Microsoft 365 Version 2302 or later, as this is a known color-conversion bug in this specific build range, and check if your documents contain conditional formatting that relies on pure RGB colors.

Solution 1Recommended

Change Pure RGB Values to 254

The most effective temporary workaround is to slightly modify the RGB values of the affected colors so they do not use the bugged '255' value.

This bug specifically targets fully saturated or desaturated colors utilizing '255' or '0' exclusively in their RGB channels. Dropping the value by just one point preserves the color visually while bypassing the conversion glitch.

Select the Cells

Highlight the affected cells in your Excel worksheet that you intend to copy.

Open More Colors

Click on the 'Fill Color' paint bucket dropdown in the Home tab and select 'More Colors'.

Adjust RGB Values

Navigate to the 'Custom' tab. In the RGB color model section, change any color channel value from '255' to '254' (e.g., change pure red from RGB 255,0,0 to 254,0,0).

Apply and Copy

Click 'OK' to apply the new color, then proceed to copy and paste the cells to Word or Outlook.

Updating Conditional Formatting: If the color is applied automatically via conditional formatting, you must edit the formatting rule itself to update the fill color using the same RGB 254 adjustment.

Solution 2

Paste Data as a Picture

If editing RGB values for hundreds of cells or conditional formatting rules is too tedious, pasting the data as an image preserves the exact visual appearance.

Solution 3

Check for Office Updates

Since this is a documented issue in a specific Microsoft 365 build, updating to the newest version may provide a permanent patch.

Free Microsoft Office alternative

Use WPS Office for Flawless Copy and Paste Formatting

Because the color loss is an inherent bug within the Microsoft Office clipboard conversion engine, switching to WPS Office provides an immediate, hassle-free resolution. WPS Office transfers data smoothly across its suite without corrupting pure RGB colors or conditional formatting.

1. Download WPS Office: Install WPS Office for free on your PC or Mac.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file.
3. Copy and Paste Seamlessly: Select the colored cells, press Ctrl+C, and paste them directly into WPS Writer or your email client perfectly intact.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and Outlook equivalents.Seamlessly copy and paste conditionally formatted cells without color loss or white fill bugs.Free, lightweight, and features a familiar user interface for zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel cell colors turn white when pasted into Outlook?

This happens due to a known color-conversion bug introduced in certain Microsoft 365 updates (such as Version 2302). The Office clipboard fails to process fully saturated RGB colors (ones containing the exact value 255), causing them to convert to a blank white fill upon pasting.

Do I need to change conditional formatting rules to fix the color loss?

Yes. If your cell colors are assigned by conditional formatting rather than manual fills, you must open the 'Manage Rules' dialog in Excel, edit the specific rule, and change the format's fill color to a custom RGB value that uses 254 instead of 255.

Is there a way to preserve Excel formatting in Outlook without altering RGB values?

Yes, you can bypass the formatting conversion completely by pasting the copied Excel cells as an image. To do this, right-click in Outlook and choose the 'Picture' icon under Paste Options, though you will not be able to edit the text afterward.

Document & File Issues