Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Joe asked in Computers & InternetSoftware · 5 years ago

Excel keep change the font color of my spreadsheet. It will be red, but when I scroll down, turns black?

We have a table template, and we use it for a lot of spreadsheets. In one particular spreadsheet we have an issue we cannot solve.

We open the spreadsheet, and the theme loads okay, the font color is correct. However, when I or another user on another computer scrolls down, and then back up. The header row reverts back to automatic font (black) and sometimes the first column. When we try to change the color, it won t allow us.

However, every time we open the file, it will load correctly.

Thank you,

Joe

1 Answer

Relevance
  • ?
    Lv 7
    5 years ago

    Hi, it may actually be how your screen is setup to display. I found a similar problem on a forum with the following solution (based on windows 7). I am also including the link where I found the solution down below. I hope it helps solve your problem.

    Fix for disappearing Excel Fill color - WINDOWS 7

    by brbhan11 / July 7, 2014 3:50 PM PDT

    In reply to: Excel fill and font color disappearing act

    Do thus:

    1. Go to: Ease of Access Center (for accessibility options) Note 1

    2. LEFT Alt/Shift/Prt Screen

    3. Click on 'Choose a High Contrast Theme' (line no. 4)

    4. Click on Windows 7

    5. Scroll down to 'Windows Classic"

    6. Click on APPLY/OK and exit/close/X Ease of Access Center

    Note 1: Click START; in bottom, blank box type in .... Ease of Access Center

Still have questions? Get your answers by asking now.