Forum Discussion

Peterpeter985's avatar
Peterpeter985
Copper Contributor
Nov 26, 2023

Formula bar in excel has black background, cannot read typed text

Formula bar in excel has black background, cannot read typed text

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Peterpeter985 

    Formula bar in Excel always has black background, perhaps the question is why text in formula bar is in black. If so. What is your Excel platform/version?

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Peterpeter985 

    If the formula bar in Excel is displaying with a black background, it could be due to a display or theme setting. You can try adjusting the settings to improve readability.

    Here are a few steps you can take:before your try the steps please make all updates.

    1. Change Theme:

    1. Go to the "File" tab.
    2. Click on "Options."
    3. In the Excel Options dialog, go to the "General" category.
    4. Look for the "Personalize your copy of Microsoft Office" section.
    5. Change the "Office Theme" to a different option (e.g., from "Dark Gray" to "Colorful").
    6. Click "OK" to apply the changes.

    2. Change Windows Theme:

    The Excel theme might be influenced by the overall Windows theme. Adjusting the Windows theme can sometimes affect the appearance of Microsoft Office applications.

    3. Adjust Excel Options:

    1. Go to the "File" tab.
    2. Click on "Options."
    3. In the Excel Options dialog, go to the "Advanced" category.
    4. Scroll down to the "Display" section.
    5. Check the option for "Disable hardware graphics acceleration."
    6. Click "OK" to apply the changes.

    4. Check High Contrast Settings:

    If your Windows display settings are set to high contrast, it can affect the appearance of Excel.

    1. Go to "Control Panel" > "Ease of Access Center" > "Make the computer easier to see."
    2. Check if the "Turn on High Contrast" option is enabled. If so, try turning it off.

    5. Update Graphics Drivers:

    Ensure that your graphics drivers are up to date. Outdated or incompatible graphics drivers can sometimes cause display issues.

     

    6.  Check System Color Settings:

    1. Right-click on your desktop and choose "Personalize."
    2. Click on "Colors" in the left sidebar.
    3. Ensure that you have a light color chosen for "Choose your color."

    7.  Repair or Reinstall Office:

    If none of the above steps resolve the issue, you may consider repairing or reinstalling Microsoft Office.

     

    After making these adjustments, restart Excel to see if the issue is resolved.

    The text and steps were edited with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark as best response and Like it!

    This will help all forum participants.

    • rjbjensen's avatar
      rjbjensen
      Copper Contributor

      Thank you for taking the time to provide your recommendation.  The issue provided solved my incident.😃

Resources