A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
I too have the same issue, my colleagues are able to copy, but not me. Just Red and Yellow are not getting copied, Green works fine...
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
After Office update to version Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20298) 64-bit
When copy paste form excel it's no color Red and Yellow.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I too have the same issue, my colleagues are able to copy, but not me. Just Red and Yellow are not getting copied, Green works fine...
Same issue red and yellow will not paste to an email.
Just tried a slightly different yellow shade and it will paste over.
Thank you for that suggestion to Morgan Fetter and John Scruggs, as it did help as a workaround. As I mentioned, some of the standard colors in the table shading are copying from Excel to Word and Outlook and other standard colors are not. I opened the color options and instead selected custom and randomly increased the RED value by 1 and the table shading colors copied properly into Word and Outlook. So it appears to be the same color to the human eye even though it's not really. Since I'm now using a non-standard color, I don't know if there will be any impact in how the non-standard color appears in the emails when they are received by the recipients not using the same application as me to view the email. By the way, all colors are stable when copying from Outlook into Excel, just not vice-versa.
Microsoft Support - Hopefully you can address for those of us with this issue so we don't have to keep using a workaround?
We have duplicated this issue and can add some data points.
255.0.0, 0.255.0, 0.0.255, 255.255.0, 255.0.255, 0.255.255, 255.255.255, and 0.0.0 all paste from Excel to Outlook with white fill. We don't care if 255.255.255 pastes as white because that is our intent. It looks like it's reading any full value in all RGB locations as 255, so 0=255 and 255=255. A fill value of 254.255.255 fills as 254.255.255. Whatever conversion that is happening is interpreting fully saturated or desaturated colors as 255.255.255
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more