Excel 2007 'Selected Items' contrast color change
Hi Experts
I have installed Office 2007 and have a question regarding Excel 2007. I would like to configure Excel 2007 so that the 'selected items' color is a contrasting color to the actual worksheet. I am struggling to see the light blue on blue selected items and would like to find out if there is a way of changing this. I have found how to change the color 'scheme' to either blue, silver or black but this does not help becuase the 'selected items' change to suite to selected scheme and still remain to light for me to clearly see. i'd like the 'selected items' color to be more of a contrast to the actual worksheet. Is this possible?
Thanks
Mustek
I have installed Office 2007 and have a question regarding Excel 2007. I would like to configure Excel 2007 so that the 'selected items' color is a contrasting color to the actual worksheet. I am struggling to see the light blue on blue selected items and would like to find out if there is a way of changing this. I have found how to change the color 'scheme' to either blue, silver or black but this does not help becuase the 'selected items' change to suite to selected scheme and still remain to light for me to clearly see. i'd like the 'selected items' color to be more of a contrast to the actual worksheet. Is this possible?
Thanks
Mustek
Will the following help you do what you want?
In Microsoft Office Excel 2007, do the following:
1. Start Excel, and then open the workbook.
2. Click the Microsoft Office Button, and then click Excel Options.
3. Click Save.
4. Next to Choose what colors will be seen in previous versions of Excel, click Colors.
5. Click the color that you want to change, and then click Modify.
6. Use one or more of the following procedures: " To replace the selected color on the palette with a different standard color, click the Standard tab, and then click the color that you want.
" To change the hue or another aspect of the selected color, click the Custom tab, and then change the options.
7. Click OK.
8. Repeat steps 5 through 7 as needed, and then click OK.
9. Click OK to close the Color dialog box.
10. Click OK to close the Excel Options dialog box.
In Microsoft Office Excel 2007, do the following:
1. Start Excel, and then open the workbook.
2. Click the Microsoft Office Button, and then click Excel Options.
3. Click Save.
4. Next to Choose what colors will be seen in previous versions of Excel, click Colors.
5. Click the color that you want to change, and then click Modify.
6. Use one or more of the following procedures: " To replace the selected color on the palette with a different standard color, click the Standard tab, and then click the color that you want.
" To change the hue or another aspect of the selected color, click the Custom tab, and then change the options.
7. Click OK.
8. Repeat steps 5 through 7 as needed, and then click OK.
9. Click OK to close the Color dialog box.
10. Click OK to close the Excel Options dialog box.
ASKER
sah18 - your recommendation is straight form the F1 Help function. I had already found this suggestion, tried it and unfortunately it does not help my problem at hand.
roos01 - your suggestion about Display>>appearance>>Advan
However, your suggestion about changing the fill color of the sheet to a contrasting color might help; would you guide me through that (i have only just installed 2007 and am still finding my feet)
Thanks
Mustek
roos01 - your suggestion about Display>>appearance>>Advan
However, your suggestion about changing the fill color of the sheet to a contrasting color might help; would you guide me through that (i have only just installed 2007 and am still finding my feet)
Thanks
Mustek
Let me try on my Excel 2007 (for me it also some kind of burder, in 2003 I could lead you blindly)
the contrasting color could be set by:
1. select all cells
2. in ribbon menu: select start
3. select the paint cann to give a light gray color.
Jeroen
the contrasting color could be set by:
1. select all cells
2. in ribbon menu: select start
3. select the paint cann to give a light gray color.
Jeroen
Perhaps this is of some help also:
http://office.microsoft.com/en-us/excel/HA101749121033.aspx#1
here is also spoken about the control panel settings.
Jeroen
http://office.microsoft.com/en-us/excel/HA101749121033.aspx#1
here is also spoken about the control panel settings.
Jeroen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
though more people, including me, find the contrast very anoying. I think there is currently no sollution for this.
I can imagine that setting the fill color is not an option.
Jeroen
I can imagine that setting the fill color is not an option.
Jeroen
I Suggest to PAQ and refund. This question might be of some help in the future. Especially the path and the comments.
regards,
Jeroen
regards,
Jeroen
Hello Vee_Mod,
I think ID: 20039695 could be accepted as there a good response and argumentation is given why those workarounds are not valid in usage.
regards,
Jeroen
I think ID: 20039695 could be accepted as there a good response and argumentation is given why those workarounds are not valid in usage.
regards,
Jeroen
ASKER
Perfect - thank you Experts
Closed, 250 points refunded.
Vee_Mod
Community Support Moderator
Vee_Mod
Community Support Moderator
One of my coworkers has a lenovo t61. I "helped" him by giving him a keyboard and an external monitor (in this case a hanssg 19" widescreen but other monitors would probably be ok)
On the t61 built in display, the contrast was NON-EXISTANT. There was absolutely no way ANYONE could see the selected cells. On the Hannsg the contrast was still bad, but a lot better than nothing. Maybe this is Microsoft's way of encouraging people to stop using laptops?
Also, several "company wide" macros like "select duplicates" end with code like "myRange.select". I changed a few of them to also say MyRange.copy. This highlights the selected areas with "chase lights". That helped a little.
If anyone is interested, the t61 discussion can be found at
https://www.experts-exchange.com/questions/23179670/How-to-improve-selected-cells-shading-in-excel-2007.html
On the t61 built in display, the contrast was NON-EXISTANT. There was absolutely no way ANYONE could see the selected cells. On the Hannsg the contrast was still bad, but a lot better than nothing. Maybe this is Microsoft's way of encouraging people to stop using laptops?
Also, several "company wide" macros like "select duplicates" end with code like "myRange.select". I changed a few of them to also say MyRange.copy. This highlights the selected areas with "chase lights". That helped a little.
If anyone is interested, the t61 discussion can be found at
https://www.experts-exchange.com/questions/23179670/How-to-improve-selected-cells-shading-in-excel-2007.html
rberke
03.03.2008 at 05:16PM EST, ID: 21036312
Here is a REAL solution. There might be simpler ways to do it, but this works on XP.
PROBLEM: in excel 2007 "selected cells" do not appear with very much contrast. On some monitors they are impossible to see.
SOLUTION under Windows XP:
find the name of your current wallpaper background which can be found by right clicking on desktop > properties > desktop > background. Write down the name, you will need it in a few minutes.
open control panel > accessibility options > display >
turn on "use high contrast" > apply
DON'T PANIC. Windows will tell you to wait. then a minute later your screen will look AWFUL. To get it back to "nearly normal" do the following.
Right click on desktop > properties > themes >
Change theme from Windows XP (modified) to Windows XP > apply
also, change your wallpaper back to its original setting.
You are now in a "nearly normal" mode where most of the high contrast options are turned off. But, Excel 2007 will have a high contract for selected cells.
To return to "completely normal" : control panel > accessiblity options > display > remove the checkbox from "use high contrast"
03.03.2008 at 05:16PM EST, ID: 21036312
Here is a REAL solution. There might be simpler ways to do it, but this works on XP.
PROBLEM: in excel 2007 "selected cells" do not appear with very much contrast. On some monitors they are impossible to see.
SOLUTION under Windows XP:
find the name of your current wallpaper background which can be found by right clicking on desktop > properties > desktop > background. Write down the name, you will need it in a few minutes.
open control panel > accessibility options > display >
turn on "use high contrast" > apply
DON'T PANIC. Windows will tell you to wait. then a minute later your screen will look AWFUL. To get it back to "nearly normal" do the following.
Right click on desktop > properties > themes >
Change theme from Windows XP (modified) to Windows XP > apply
also, change your wallpaper back to its original setting.
You are now in a "nearly normal" mode where most of the high contrast options are turned off. But, Excel 2007 will have a high contract for selected cells.
To return to "completely normal" : control panel > accessiblity options > display > remove the checkbox from "use high contrast"
A suggestion could be to change the fill color of the sheet to for instance light gray. Perhaps this is valid as a workaround.
Perhaps setting in the configuration panel: Display>>appearance>>Advan
the selected items to a different color also might help out. Though this will count for all applications.
regards,
Jeroen