Tinting Excel Background to Show White Text In Windows Settings

dave1982

New Member
Joined
Mar 1, 2024
Messages
4
Office Version
  1. 365
Platform
  1. Windows
When working in excel at a prior company we should change the settings in windows so the background in excel workbooks would have a slight blue tint so we could see white text in our workbooks; however, I can't find a way to do this in Windows 365. Does anyone know how to do thin in Windows 365?

Note: This is not changing the fill color in the workbook or excel sheet, this was done as part of the display settings in older versions of windows.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
I know of a way you can do this through vba.

Here is an online VBA script on GitHub that will change the background to a 'dark mode' setting. Inside of that code you can change the hex code to whatever color you want.

This is from the GitHub description

VBA Code:
   Call UpdateStyleColors(styleName:="Normal", fillColorHex:="#2E3440", fontColorHex:="#FFFFFF", borderColorHex:="#454545")
 
Upvote 0
On the main menu bar select HOME / FONT. The background color is shown as YELLOW and the font color is displayed as RED. Click on each one and
change to the light blue and white.

You should also be able to adjust the colors by selecting PAGE LAYOUT on the main menu bar. Then THEMES / COLORS. You can then select CREATE NEW THEME, then "Text/Background - Dark 1" and adjust the two colors as needed.
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,252
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top