SOLVED

Wrong background colours in Excel (Office 365)

%3CLINGO-SUB%20id%3D%22lingo-sub-1114512%22%20slang%3D%22en-US%22%3EWrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114512%22%20slang%3D%22en-US%22%3E%3CP%3ESince%20two%20days%20I%20cannot%20fill%20my%20cells%20with%20the%20right%20colours.%20I'm%20using%20Windows%2010%20and%20Office%20365.%3C%2FP%3E%3CP%3EWhen%20the%20colour%20red%2C%20orange%20or%20yellow%20is%20selected%20and%20I%20try%20to%20change%20the%20background%20colour%20of%20the%20cell%20it%20turns%20purple.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20dark%20red%2C%20light%20green%20or%20purple%20is%20selected%20and%20I%20try%20to%20change%20the%20background%20colour%20of%20the%20cell%20it%20stays%20white.%3C%2FP%3E%3CP%3EWhen%20the%20colour%20green%2C%20light%20blue%2C%20blue%20or%20dark%20blue%20is%20selected%20and%20I%20try%20to%20chaange%20the%20beackground%20colour%20of%20the%20cell%20it%20turns%20light%20blue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECells%20that%20had%20a%20different%20background%20colour%20before%20the%20above%20occurred%20have%20the%20right%20colour%20(e.g.%20yellow).%20When%20I%20copy%20hese%20cells%20and%20paste%20the%20format%20in%20another%20cel%20the%20color%20changes%20as%20described%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20working%20in%20high%20contrast%20mode%20and%20when%20trying%20to%20change%20the%20text%20colour%20in%20a%20cell%20there's%20no%20trouble%20at%20all......%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20having%20simular%20problems%20or%20having%20a%20solution%20to%20solve%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1114512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1114565%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114565%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20upload%20a%20sample%20file%20so%20that%20I%20cab%20test%20from%20my%20office%20365%20here!%20That%20might%20guide%20us%20to%20the%20cause%20of%20the%20problem%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1114578%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20attached%20sample%20file.%3C%2FP%3E%3CP%3EI%20even%20tried%20a%20complete%20repair%20of%20my%20365%20installation.%3C%2FP%3E%3CP%3EAll%20programs%20have%26nbsp%3Bbeen%20downloaded%20again%2C%20but%20there's%20still%20something%20wrong.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1114611%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114611%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20can%20see%20that%20the%20workbook%20is%20saved%20as%20%22Excel%2097-2003%20Workbook%20(*.xls).%3CBR%20%2F%3EKindly%20re-save%20as%20Excel%20Workbook%20(*xlsx).%3CBR%20%2F%3E%3CBR%20%2F%3EWith%20regardless%20to%20the%20font%20and%20fill%20colour%2C%20I%20applied%20font%20and%20fill%20colors%20to%20many%20of%20the%20cells%20and%20they%20all%20formula%20without%20any%20issue.%20See%20the%20attached%20pictures%20and%20the%20new%20workbook...%3CBR%20%2F%3E%3CBR%20%2F%3ELooking%20forward%20to%20hear%20from%20you%20%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1114743%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114743%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20all%20effort.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20my%20last%20post%20I%20found%20another%20major%20problem%3B%20when%20I%20tried%20to%20open%20the%20properties%20of%20a%20cell%20(right%20click)%20Excel%20crashed%20(!).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%26nbsp%3Bproblem%20AND%20the%20colour%20problem%20have%20been%20solved%20bij%20removing%20the%20complete%20Office%20365%20installation%2C%20including%20all%20related%20Microsoft%20programs%20and%20making%20a%20totally%20clean%20install%20(so%20not%20using%20the%20Microsoft%20repair%20function%20which%20I%20used%20before%20-%20which%20seemed%20to%20make%20a%20clean%20install).%3C%2FP%3E%3CP%3EI%20presume%20during%20the%20last%20(minor)%20Office%20365%20update%20something%20had%20been%20corrupted%2C%20causing%20both%26nbsp%3Bproblems.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20all%20is%20working%20OK%20right%20now!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain%2C%20thanks%20for%20all%20your%20trouble!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1114785%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114785%22%20slang%3D%22en-US%22%3EGood%20to%20hear%20that%20all%20is%20working%20fine%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2076956%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076956%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BI'd%20like%20to%20do%20a%20reinstall%20cuz%20I%20have%20had%20similar%20problems%20in%20all%20of%20the%20365%20programs%20since%20Day%201%20of%20my%20subscription.%20How%20do%20I%20do%20it%3F%20Call%20Support%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2091044%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20background%20colours%20in%20Excel%20(Office%20365)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2091044%22%20slang%3D%22en-US%22%3EJust%20remove%20all%20365%20programs%20in%20Windows%20by%20configuration%2Fapps%2F%20and%20reinstall%20all%20programs%20bij%20logging%20in%20to%20your%20365%20account.%20Worked%20for%20me!%20Good%20luck!%3C%2FLINGO-BODY%3E
Occasional Contributor

Since two days I cannot fill my cells with the right colours. I'm using Windows 10 and Office 365.

When the colour red, orange or yellow is selected and I try to change the background colour of the cell it turns purple. 

When dark red, light green or purple is selected and I try to change the background colour of the cell it stays white.

When the colour green, light blue, blue or dark blue is selected and I try to chaange the beackground colour of the cell it turns light blue.

 

Cells that had a different background colour before the above occurred have the right colour (e.g. yellow). When I copy hese cells and paste the format in another cel the color changes as described above.

 

I'm not working in high contrast mode and when trying to change the text colour in a cell there's no trouble at all......

 

Anyone having simular problems or having a solution to solve this issue?

7 Replies
Hello,

Can you upload a sample file so that I cab test from my office 365 here! That might guide us to the cause of the problem

@Abiola1 

 

See the attached sample file.

I even tried a complete repair of my 365 installation.

All programs have been downloaded again, but there's still something wrong. 

best response confirmed by Abiola1 (MVP)
Solution
Hello,

I can see that the workbook is saved as "Excel 97-2003 Workbook (*.xls).
Kindly re-save as Excel Workbook (*xlsx).

With regardless to the font and fill colour, I applied font and fill colors to many of the cells and they all formula without any issue. See the attached pictures and the new workbook...

Looking forward to hear from you

@Abiola1 

 

Thanks for all effort.

 

After my last post I found another major problem; when I tried to open the properties of a cell (right click) Excel crashed (!).

 

This problem AND the colour problem have been solved bij removing the complete Office 365 installation, including all related Microsoft programs and making a totally clean install (so not using the Microsoft repair function which I used before - which seemed to make a clean install).

I presume during the last (minor) Office 365 update something had been corrupted, causing both problems.

 

So all is working OK right now!

 

Again, thanks for all your trouble!

Good to hear that all is working fine

@Abiola1 I'd like to do a reinstall cuz I have had similar problems in all of the 365 programs since Day 1 of my subscription. How do I do it? Call Support? 

Just remove all 365 programs in Windows by configuration/apps/ and reinstall all programs bij logging in to your 365 account. Worked for me! Good luck!