• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6649
  • Last Modified:

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
0
mustekkzn
Asked:
mustekkzn
  • 6
  • 3
  • 2
  • +2
1 Solution
 
Jeroen RosinkCommented:
I tried to search for it in Excel 2007 and also on the net. I couldn't find any sollution. Even in Microsoft knowledge base there is no solution mentioned.

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>>Advance button

the selected items to a different color also might help out. Though this will count for all applications.

regards,
Jeroen
0
 
sah18Commented:
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.
0
 
mustekkznAuthor Commented:
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>>Advance button yields nothing. I have excel 2003 and excel 2007 installed on the same PC and the only pone affected is excel 2003 with changing the 'selected items' color.
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
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
Jeroen RosinkCommented:
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
0
 
Jeroen RosinkCommented:
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
0
 
mustekkznAuthor Commented:
roos01 - I have found that the suggestion about changing the fill color of the cells is actually not an option. It actually defeats the purpose of the 'fill' function and the users that are using the Excel 2007 documents actually uses cell fill colors often, so I cannot run the risk of changing the cell fill option by defualt or everytime.
Your next suggestion, with regards to http://office.microsoft.com/en-us/excel/HA101749121033.aspx#1 is actually something I did try before posting this question. It only changes the color 'scheme' to either blue, silver or black but this does not help becuase the 'selected items' change to suite the selected scheme and still remain too light for me to clearly see. (as stated in my original posting)
0
 
Jeroen RosinkCommented:
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
0
 
Jeroen RosinkCommented:
I Suggest to PAQ and refund. This question might be of some help in the future. Especially the path and the comments.
regards,
Jeroen
0
 
Jeroen RosinkCommented:
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
0
 
mustekkznAuthor Commented:
Perfect - thank you Experts
0
 
Vee_ModCommented:
Closed, 250 points refunded.
Vee_Mod
Community Support Moderator
0
 
rberkeCommented:
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
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23179670.html
0
 
rberkeCommented:
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"

0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 6
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now