Excel automatic colour changes

%3CLINGO-SUB%20id%3D%22lingo-sub-1573277%22%20slang%3D%22en-US%22%3EExcel%20automatic%20colour%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573277%22%20slang%3D%22en-US%22%3E%3CP%3Emy%20students%20are%20carrying%20out%20arithmetical%20calculations%20on%20the%20excel%20spreadsheets.%26nbsp%3B%20They%20enter%20figures%20in%20black%20but%20I%20have%20to%20enter%20marks%20in%20red.%20Everytime%20I%20change%20the%20colour%20to%20red%20it%20automatically%20changes%20back%20to%20black%20when%20I%20move%20to%20the%20next%20set%20of%20figures%20.%20Can%20I%20stop%20the%20constant%20change%20back%20to%20black%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573277%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573361%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20automatic%20color%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573361%22%20slang%3D%22de-DE%22%3EIt%20would%20be%20an%20advantage%20if%20you%20insert%20a%20file%20with%20the%20problem%20(without%20sensitive%20data)%2C%20so%20you%20could%20come%20to%20a%20solution%20much%20faster%20and%20we%20might%20provide%20you%20with%20better%20solution%20proposals.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20It's%20probably%20because%20of%20the%20formatting%20of%20the%20cells.%20%3CBR%20%2F%3E%20But%20you%20can%20only%20be%20sure%20if%20you%20could%20see%20the%20problem.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

my students are carrying out arithmetical calculations on the excel spreadsheets.  They enter figures in black but I have to enter marks in red. Everytime I change the colour to red it automatically changes back to black when I move to the next set of figures . Can I stop the constant change back to black?

 

Thanks

1 Reply
It would be an advantage if you insert a file with the problem (without sensitive data), so you could come to a solution much faster and we might provide you with better solution proposals.

It's probably because of the formatting of the cells.
But you can only be sure if you could see the problem.



Nikolino
I know I don't know anything (Socrates)