Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel font color doesn change on changing windows high contrast mode

06 Sep 2018   #1
rvsw

windows 7 ultimate x64
 
 
Excel font color doesn change on changing windows high contrast mode

Because of problems with my eyes, I often use windows in high contrast which is essentially as I understand, can be described as of Windows theme with dark colours. When I start Microsoft Excel 2010 on Windows 7 in high contrast mode, the Microsoft Excel background is black and the foreground is white like any other application in Microsoft Office, including Microsoft Outlook 2010.

When I send a Microsoft Excel file to someone else who is not using the more conventional Windows themes, their background is white. Since the foreground is also white, they do not see anything.
I face the same issue if I ever change my theme setting from high contrast to conventional Windows 7 themes.
I have to manually select the entire worksheet and then change the foreground colour to black
.
But this is not a problem in Microsoft Outlook. For example, if I have any drafts in Microsoft Outlook 2010 and I change the Windows key from high contrast to conventional Windows 7, then the foreground and background colour automatically change.

And this is the same behaviour that I see in other Windows application including notepad.

I have looked around for answers on this but could not find anything. I also looked in Microsoft Office settings but again there was no success. So I'm posting this query here in the hope of a solution.

If the direct solution is not possible, is there a possibility of a workaround in which I open Microsoft Excel and it automatically detects if Windows is in high contrast mode or at least the default background colour and then adjust the foreground colour? I was hoping to include this as a macro in Microsoft Excel so that I can send it to recipients of my Microsoft Excel file and they can run it instead of me asking them every time to change the foreground colour
. Thank you for any inputs


My System SpecsSystem Spec
.
06 Sep 2018   #2
Paul Black

Win 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi rvsw,

I think you will probably need to use something like a Workbook Object in Excel VBA. You could then use the method Workbook_Open(). Code placed in this method will execute when you open the Excel Workbook.

I am sure that there is somebody here that will be able to write some VBA code to do this for you!

The recipient will of course need to have Macros enabled!

Excel Options > Trust Centre > Trust Centre Settings > Macro Settings > and tick the desired Macro Setting.

I hope this helps!
My System SpecsSystem Spec
06 Sep 2018   #3
rvsw

windows 7 ultimate x64
 
 

Thank you for your prompt response. I will check the workbook object. Yes I understand that the recipients need to have their macros enabled in Microsoft Excel.

However, I was hoping that this would be the last option. I was hoping to find some configuration setting that can be modified so that this behaviour is not seen.
My System SpecsSystem Spec
.

Reply

 Excel font color doesn change on changing windows high contrast mode




Thread Tools




Similar help and support threads
Thread Forum
Changing Font color on Windows 7 Start menu
I've gone into Control Panel/Change windows colors and metrics and changed all the font colors on all categories I think... but the Start menu font is still black although it did change the font default to Comic Sans MS. I'd like the color to be red.
Customization
Changing font size and color for message list on Windows Live Mail
I am trying to help friend out that just migrated from Outlook Express on Windows XP to Windows Live Mail 2012 on Windows 7 Home Premium x64. She has trouble reading the from and subject lines after the client marks them as read. I am aware of how to change the default font settings for the...
Browsers & Mail
After High Contrast Mode no Aero anymore.
dI'm new to this forum so first at all hello guys and gals :3 So back to topic I was playing APB: Reloaded(Window Mode) and running with shift, then I've seen something funny and I wanted to make a screenshot of it so I pressed Alt+Shift+Print Screen... Well I didn't know that I get into...
Customization
Selected text color while using high contrast
Hi, I'm using Office 2010 on Windows 7 (64bit) with high contrast theme (white on black). When i select part of the text (in a word document, for instance) the selected text is highlighted with white background color. Is it possible to change the background color and the font color of the...
Microsoft Office
Can't change application background with High contrast theme
If I select a black high contrast theme in Win7 I cannot change the background color of MS Word 2000, any suggestions? thanks...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:16.
Twitter Facebook