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

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.


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 17

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

809 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