Fix Excel for the Web Not Copying Conditional Formatting Colors to Outlook
Question details
The user needs to copy a range from Excel for the web into Outlook while keeping conditional formatting fill colors. The same operation works in desktop Excel, but the web version omits the colors.
- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- Copying conditionally formatted cell ranges from Microsoft Excel for the web into an Outlook email.
- Observed behavior
- Excel for the web omits conditional formatting colors when pasted into Outlook, even though the same range copies correctly in desktop Excel and across multiple browsers.
Confirm that the conditional formatting rule is active in the source workbook and that you can see the expected fill colors in Excel for the web. If the range must remain editable in the email, use the desktop Excel app instead of a screenshot.
Copy the range from the desktop Excel application instead of Excel for the web
Use this solution when you need to keep conditional formatting colors in Outlook and have access to the installed Microsoft Excel desktop app.
The desktop Excel application handles clipboard formatting more completely than Excel for the web. This method keeps live cell content and formatting, so recipients can continue to view and edit the data.
Download or save the workbook, then open it in the desktop Excel application instead of Excel for the web.
Select the conditionally formatted range, right-click it, and choose Copy, or press Ctrl+C.
Place the cursor in the email body, right-click, and choose the paste option that keeps source formatting.
Insert a screenshot of the formatted range with Snipping Tool
Use this solution when you cannot open desktop Excel or only need to share a static view of the formatted cells.
Use WPS Office Spreadsheets for Reliable Conditional Formatting and Excel Compatibility
If Excel for the web keeps dropping conditional formatting colors when you copy to Outlook, WPS Office is a free, lightweight Microsoft Office alternative with familiar formatting tools and full .xlsx compatibility, so you can open, edit, and copy formatted workbooks without losing visual rules.
- 1. Download and install WPS Office: Go to the official WPS Office download page and install WPS Office Free.
- 2. Open the Excel workbook: Launch WPS Spreadsheets, click Open, and select the .xlsx workbook.
- 3. Copy the formatted range: Select the conditionally formatted cells, copy them, and paste them into Outlook or another email client.
Frequently Asked Questions
Why does Excel for the web remove conditional formatting colors when I copy a range into Outlook?
This is a known behavior in some Microsoft 365 updates. The web app may not carry the formatting metadata into the Outlook paste operation, while the desktop Excel app retains it because it handles clipboard formatting differently.
Is this a browser-specific problem?
No. The same behavior has been reproduced across multiple browsers, which suggests it is related to Excel for the web or the Microsoft 365 service rather than one specific browser.
How can I keep the colors if I do not have desktop Excel?
You can use a screenshot tool such as Snipping Tool to capture the formatted range and insert the image into Outlook, or open the workbook in WPS Office Spreadsheets and copy the range from there.
Will a screenshot preserve the conditional formatting colors?
Yes. A screenshot shows the colors exactly as displayed, but the cells become an image and are no longer editable as spreadsheet data.
Can WPS Office open my Excel file without losing conditional formatting?
WPS Office Spreadsheets supports Excel .xlsx workbooks and retains conditional formatting for display and copying, making it a free alternative for this workflow.
