Hi everyone,
I have a spreadsheet that opens in Protected View with the yellow notification bar at the top with the button to "Enable Editing". When I first open the spreadsheet and am in Protected View mode, everything looks normal. Once I click "Enable Editing", however, all of the black text (which is most of the file) turns to gray and is barely legible. Cells formatted with other colors are unaffected (ie. the heading at the top with font color blue stays blue after I enable editing). When I right click any of the cells that changed to gray, the formatting settings for font look like this:
Font Color.JPG
As you can see, the font is set to black, but the preview shows the gray color that I see after I enable editing. If I click the color dropdown and select either black or Automatic, it will fix that cell and turn the font color back to black. Checking the "Normal font" box in that window will also turn the font color back to black (but also changes the font and font size so that's not ideal). My question is this: What is causing this issue? The color seems to be set to black, but it isn't displaying as black until I go to Format Cells and set it to black again. Is the initial "black" missing from my color palette maybe (I am receiving this file from another company I do business with)? Is there anyway to fix all of these at once vs. selecting each affected cell and changing the font to black. Thanks for the help!
Bookmarks