+ Reply to Thread
Results 1 to 5 of 5

Text displays different color than it is set to. Color palette issue?

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    NYC
    MS-Off Ver
    Microsoft 365 (Version 2304, 64-Bit), Win11
    Posts
    23

    Text displays different color than it is set to. Color palette issue?

    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!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,843

    Re: Text displays different color than it is set to. Color palette issue?

    Never heard of this before. Can you attach your file? If it has sensitive data you can put fake data in just one cell to demonstrate the problem and strip out everything else.

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    NYC
    MS-Off Ver
    Microsoft 365 (Version 2304, 64-Bit), Win11
    Posts
    23

    Re: Text displays different color than it is set to. Color palette issue?

    Thanks for the response. Please see the attached file. I stripped the sensitive data but left enough cells so you can (hopefully) see what I am seeing.

    Test.xls

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,843

    Re: Text displays different color than it is set to. Color palette issue?

    Sorry, what I see looks perfectly normal.
    notgray.png

  5. #5
    Registered User
    Join Date
    09-05-2012
    Location
    NYC
    MS-Off Ver
    Microsoft 365 (Version 2304, 64-Bit), Win11
    Posts
    23

    Re: Text displays different color than it is set to. Color palette issue?

    Strange, I wonder if saving it on my machine before sharing it here did anything? Is there anything else you can think of that I should check? This has happened a few times and is a major pain to find all the affected cells and correct them. I can Ctrl+A and set everything to black, but that isn't ideal.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change color in a picture using a color palette.
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2014, 02:45 AM
  2. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  3. color palette stuck on one color
    By JonRT in forum Excel General
    Replies: 1
    Last Post: 10-22-2008, 04:39 PM
  4. Color Palette, color disappears
    By Emil in forum Excel General
    Replies: 3
    Last Post: 11-29-2005, 01:07 AM
  5. [SOLVED] Different color palette
    By Luc Benninger in forum Excel General
    Replies: 1
    Last Post: 07-05-2005, 05:16 AM
  6. [SOLVED] VBA color palette
    By Holanmeg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2005, 05:06 AM
  7. [SOLVED] Color Palette
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2005, 03:06 PM
  8. [SOLVED] Color Palette Issue
    By Scott McDonald in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1