Go Premium for a chance to win a PS4. Enter to Win


format Cells color  In Excell Sheet

Posted on 2014-04-13
Medium Priority
Last Modified: 2014-09-29
i have excell sheet , i set background color is white , front is black , no borders
sometimes , while working in the sheet , i found the data suddenly back & front white color  in temp time
then it be back to appear as black front
any idea about how to solve this issue ?
Question by:NiceMan331

Assisted Solution

XGIS earned 1000 total points
ID: 39998345
Hello NiceMan331..
Maybe it is best to let excel format for you.
Even using a colour scheme for a table can lead to issues if you have to copy or move cells, and the alternating cells are then misaligned.

If you have set a default background to white and you enter a new cell maybe it is simply ignoring your custom settings that relate to OTHER cells.

Since the background is white by default it may be best to NOT use a white fill.
Alternatively consider using the schemes, assuming your excel is 2007 or greater.

This may save time instead of altering the look and feel when you are actively editing.

Author Comment

ID: 39998360
hello xgis

Alternatively consider using the schemes
yes i have excell 2007 , could you please explain how to use this scheme ?

Author Comment

ID: 39998436
i just found now that the problem is not execlusive to white colour
when i changed the foreground to any other clour , it displayed white from clour also
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 40010365
Hello NiceMan331  Please check this Microsoft step by step tutorial to resolve this issue.


If you still have issues have issues select all cells by clicking the start or origin cell 0,0 above A and left of 1 to change the FONT colour of all to Auto or Black and Fill Cells to Automatic.

Failing that you can copy all the values onto a new sheet and paste them as "values" Assuming you have no formulas or other sheet based dependencies. This should remove any formatting issues.  

Maybe try and use the styles to make cells standout temporarily or permanently.

Hope this helps...
LVL 18

Accepted Solution

Karen Falandays earned 1000 total points
ID: 40010380
Hi Niceman331
I think XGIS was speaking of themes, but here is an easier solution:
If you want to use Excel's default format of clear background and black font, simply remove all of the formatting that has been put on this spreadsheet.

Select all of the cells (Ctrl+A...you may need to do this twice to select the entire worksheet)
On the Home tab, find the clear button.
Click to clear formats

Let me know if that does the trick
LVL 70

Expert Comment

ID: 40010464
This is normal !
When a cell is being edited the colours reverse

Author Comment

ID: 40031368
i'm so sorry for all
i just waiting for the case to happen again with me
but i surprised it not repeated again
till now all fields are ok , without any changes i did

any how , is it fare to close the question and accept all answer dividing the points equally ?

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question