Formatting Issues

Fix Excel Conditional Formatting Colors Missing in Outlook Email

Emma Brown Oct 16, 2026 870 views

Question details

The user is experiencing an issue where background colors applied via conditional formatting in Excel disappear or do not render properly when copied and pasted into an Outlook email.

How to Fix Excel Conditional Formatting Colors Missing in Outlook Email

Product: Microsoft Excel / Microsoft Outlook
Device & OS: not provided
Scenario: Copying formatted cell ranges from an Excel spreadsheet and pasting them into the body of an Outlook email message.
Observed behavior: When using the 'Keep Source Formatting' paste option, some or all of the conditional formatting fill colors fail to appear in the Outlook email.

Before you start

Before you begin, ensure you have finalized your spreadsheet data, as the recommended workaround involves converting the data to a static format that cannot be edited from within the email body.

Solution 1Recommended

Use the Paste as Picture Option

Bypass Outlook's HTML formatting limitations by pasting the Excel data as an image, ensuring all conditional formatting rules and colors are preserved exactly as they appear on screen.

Microsoft Outlook uses Word's HTML rendering engine for email bodies, which sometimes fails to accurately translate complex Excel conditional formatting rules via the clipboard. Converting the data to a picture during the paste process avoids this conversion error entirely.

Copy the Excel Range

Open your Excel spreadsheet. Highlight the range of cells containing the conditional formatting you want to share, and press Ctrl+C (or right-click and select Copy).

Navigate to Your Email

Open Microsoft Outlook and either compose a New Email or reply to an existing thread.

Apply Paste as Picture

Right-click in the message body where you want the data to appear. Under the 'Paste Options' menu, select the 'Picture' icon (it looks like a small landscape with a mountain and sun).

Formatting Guaranteed: Because the data is inserted as a static image, you can be 100% certain your recipients will see the exact same colors and formatting that you see in Excel.

Solution 2

Capture and Paste a Screen Clipping

If standard clipboard paste options are unavailable or failing, using your system's built-in screenshot tool achieves the same visual result.

Seamlessly Share Formatted Data

Use WPS Spreadsheet to Easily Share Formatted Data as Images

WPS Office offers a dedicated 'Export to Picture' tool directly inside the spreadsheet app, allowing you to instantly convert complex formatting into high-quality images for seamless email sharing without clipboard bugs.

1. Open File in WPS Spreadsheet: Launch WPS Office and open the .xlsx document containing your conditional formatting rules.
2. Select Your Data: Highlight the specific cell range that you want to share with your email recipients.
3. Export as Picture: Right-click the highlighted area and select 'Save as Picture' from the context menu, or utilize the Camera tool under the Insert tab.
4. Insert into Email: Save the image to your device and insert it into any email client, guaranteeing perfectly retained formatting.

Built-in 'Save as Picture' tool for any selected cell rangeMaintains 100% compatibility with Microsoft Excel (.xlsx) filesCompletely free, lightweight, and fast alternative to heavy Office suitesEnsures conditional formatting rules display perfectly for email recipients

microsoft office alternative - wps office

Frequently Asked Questions

Why does 'Keep Source Formatting' fail to show conditional colors in Outlook?

Outlook relies on an HTML engine to render email bodies. Complex Excel features, particularly conditional formatting algorithms, do not always translate well into static HTML code via the system clipboard, resulting in dropped or missing background colors.

Can I edit the data in Outlook after pasting it as a picture?

No. When you use the 'Paste as Picture' option, the copied cells are converted into a static image file. You will not be able to edit the text, numbers, or formulas within the email body.

How do I fix this if I need the data to remain editable in the email?

If your recipients must be able to copy or edit the text directly from the email, you will need to manually apply standard static fill colors to the cells in Excel before copying, or simply attach the original Excel file to the email instead.

Document & File Issues