Forum Discussion
Solved
Colours of conditional formatiing are changing when copying from one workbook to another
Hi
I am using Excel 2016 and I have a spreadsheet with colour coding on it (this spreadsheet is saved in OneDrive). When I copy this to another Excel workbook the colours of the conditional formatting are completely different. Why would this be?
After further investigation i think my colour palette has changed when i upgraded to 2016. Is there anyway I can get this back?
2 Replies
After further investigation i think my colour palette has changed when i upgraded to 2016. Is there anyway I can get this back?
Craig Dixon Go to Page Layout and look at the Themes. The sheets will have different colour themes. If the theme in the old version is still there in the new version just click on it to set the colours back to how they were.
