Colour appears different from selected

[lemonbarley]

Hi everyone! I'm on O365.

When I download a report from a web-based system, the colours are easy on the eyes. When I transfer the data into a new worksheet, the colours change and make the data hard to read. On both original and new worksheet, the colour theme is the same, so doesn't seem like a matter of the report using theme colours.

What is really strange is on the report, when I go to More Colours to look at what colour was selected for a Teal-coloured cell, it shows Blue being selected (cellcolour.png). This is the colour which does appear when I have the data in the new worksheet (newworksheet.png). I've attached the images, I hope this helps you understand what I mean.

There is no conditional formatting or any vba coding in the report. When downloaded, the report is in .xls format. I use File > Info > Convert to convert it to .xlsx and it turns off compatibility mode after reopening it.

I don't have the power to adjust the formatting in the report template before the report is generated so any insights / solution after-the-fact would be very much appreciated!

Thank you!

 

[sijpie]

that is kind of weird. My first thought was indeed the colour theme in place. Are you really sure they are the same? Can you check which scheme is being used on the template? (Menu: Page Layout/Templates)
Have you tried the various templates available on your copy?

I think the makers of the template have modified their standard colour scheme. Then when you copy, Excel uses your standard scheme. And that is a different one.

 

[lemonbarley]

I went to Page Layout / Themes and Office was definitely selected. When I changed to other Themes, the colours do not change.
Tried changing the Color palette as well.

 

[sijpie]

Mmh. Baffles me then.
If you download the report often, then you (or I) could write a macro to change the colours to the ones you want.