format Cells color  In Excell Sheet

Posted on 2014-04-13
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Assisted Solution

XGIS earned 250 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.


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 250 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 ( 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

724 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