Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello
I have a problem with the fonts being white in various cells. I'm wondering if a prankster at work is messing with me. At first you think that the cell is just blank, but after I did a select all and all the cells were highlighted, I could see that the font is actually white in random cells. I use excel a whole lot and I don't see anything that would cause this. Using format cell, nothing appears to be different from the other cells that are okay. If I do a copy and paste from a good cell, the font remains white. I read up in help about a person could type in three semicolons to do this, under format cells, but that also doesn't appear to be the case. I actually deleted out about thirty rows of cells that I could see white fonts in (I had previously copied mathematical formulas.) and then I had a row that the cell was okay I have spent about an hour trying to see what the problem is on this one spreadsheet. I hope someone can help. |
#2
![]() |
|||
|
|||
![]()
Hi!
Another thing to check for is conditional formatting. Select one of the cells that has a white font. Then goto FormatConditional Formatting. Do you see any settings? Biff "Jon" wrote in message ... Hello I have a problem with the fonts being white in various cells. I'm wondering if a prankster at work is messing with me. At first you think that the cell is just blank, but after I did a select all and all the cells were highlighted, I could see that the font is actually white in random cells. I use excel a whole lot and I don't see anything that would cause this. Using format cell, nothing appears to be different from the other cells that are okay. If I do a copy and paste from a good cell, the font remains white. I read up in help about a person could type in three semicolons to do this, under format cells, but that also doesn't appear to be the case. I actually deleted out about thirty rows of cells that I could see white fonts in (I had previously copied mathematical formulas.) and then I had a row that the cell was okay I have spent about an hour trying to see what the problem is on this one spreadsheet. I hope someone can help. |
#3
![]() |
|||
|
|||
![]()
If you don't mind a single font color, select all the cells in the worksheet.
Then pull-down: Format Cells... Font and select the black color. -- Gary's Student "Jon" wrote: Hello I have a problem with the fonts being white in various cells. I'm wondering if a prankster at work is messing with me. At first you think that the cell is just blank, but after I did a select all and all the cells were highlighted, I could see that the font is actually white in random cells. I use excel a whole lot and I don't see anything that would cause this. Using format cell, nothing appears to be different from the other cells that are okay. If I do a copy and paste from a good cell, the font remains white. I read up in help about a person could type in three semicolons to do this, under format cells, but that also doesn't appear to be the case. I actually deleted out about thirty rows of cells that I could see white fonts in (I had previously copied mathematical formulas.) and then I had a row that the cell was okay I have spent about an hour trying to see what the problem is on this one spreadsheet. I hope someone can help. |
#4
![]() |
|||
|
|||
![]()
Hello Biff and Gary's Student
I already tried changing the font color various ways and it wouldn't work. Tommorrow when I go back to work, I will go into one of the actual cells messed up and look at the conditional formatiing. I already looked at it, but I may have not been in a messed up cell. I really believe that a deadbeat that don't know what work is did this on purpose. But again, I may be crazy. Thank you "Biff" wrote: Hi! Another thing to check for is conditional formatting. Select one of the cells that has a white font. Then goto FormatConditional Formatting. Do you see any settings? Biff "Jon" wrote in message ... Hello I have a problem with the fonts being white in various cells. I'm wondering if a prankster at work is messing with me. At first you think that the cell is just blank, but after I did a select all and all the cells were highlighted, I could see that the font is actually white in random cells. I use excel a whole lot and I don't see anything that would cause this. Using format cell, nothing appears to be different from the other cells that are okay. If I do a copy and paste from a good cell, the font remains white. I read up in help about a person could type in three semicolons to do this, under format cells, but that also doesn't appear to be the case. I actually deleted out about thirty rows of cells that I could see white fonts in (I had previously copied mathematical formulas.) and then I had a row that the cell was okay I have spent about an hour trying to see what the problem is on this one spreadsheet. I hope someone can help. |
#5
![]() |
|||
|
|||
![]()
After trying Biff's suggestion, make sure the cells are not protected.
If you are convinced that evil forces are at work, Start Excel in Safe Mode and then try to change the font color. -- Gary's Student "Jon" wrote: Hello Biff and Gary's Student I already tried changing the font color various ways and it wouldn't work. Tommorrow when I go back to work, I will go into one of the actual cells messed up and look at the conditional formatiing. I already looked at it, but I may have not been in a messed up cell. I really believe that a deadbeat that don't know what work is did this on purpose. But again, I may be crazy. Thank you "Biff" wrote: Hi! Another thing to check for is conditional formatting. Select one of the cells that has a white font. Then goto FormatConditional Formatting. Do you see any settings? Biff "Jon" wrote in message ... Hello I have a problem with the fonts being white in various cells. I'm wondering if a prankster at work is messing with me. At first you think that the cell is just blank, but after I did a select all and all the cells were highlighted, I could see that the font is actually white in random cells. I use excel a whole lot and I don't see anything that would cause this. Using format cell, nothing appears to be different from the other cells that are okay. If I do a copy and paste from a good cell, the font remains white. I read up in help about a person could type in three semicolons to do this, under format cells, but that also doesn't appear to be the case. I actually deleted out about thirty rows of cells that I could see white fonts in (I had previously copied mathematical formulas.) and then I had a row that the cell was okay I have spent about an hour trying to see what the problem is on this one spreadsheet. I hope someone can help. |
#6
![]() |
|||
|
|||
![]()
Hello Biff
That was definetely it. The girl that created the spreadsheet is very good with excel. I quess she thinks everyone else is too. I believe that I might have to experiment with conditional formatting in my personal spreadsheets. Looks like it may be easier than macros in some cases. Thanks very much again. "Biff" wrote: Hi! Another thing to check for is conditional formatting. Select one of the cells that has a white font. Then goto FormatConditional Formatting. Do you see any settings? Biff "Jon" wrote in message ... Hello I have a problem with the fonts being white in various cells. I'm wondering if a prankster at work is messing with me. At first you think that the cell is just blank, but after I did a select all and all the cells were highlighted, I could see that the font is actually white in random cells. I use excel a whole lot and I don't see anything that would cause this. Using format cell, nothing appears to be different from the other cells that are okay. If I do a copy and paste from a good cell, the font remains white. I read up in help about a person could type in three semicolons to do this, under format cells, but that also doesn't appear to be the case. I actually deleted out about thirty rows of cells that I could see white fonts in (I had previously copied mathematical formulas.) and then I had a row that the cell was okay I have spent about an hour trying to see what the problem is on this one spreadsheet. I hope someone can help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
how do I count cells with only red font? | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |