+ Reply to Thread
Results 1 to 4 of 4

Selected Cell Highlighting

  1. #1
    Forum Contributor boylejob's Avatar
    Join Date
    02-22-2007
    Location
    Forest City, NC
    MS-Off Ver
    2003
    Posts
    562

    Selected Cell Highlighting

    My hard drive crashed at work today and I got upgraded to Excel 2007. I am having some trouble getting it adjusted to suit my needs. Is there a way to adjust the color of selected cells. When you click on a column or a row or you select a cell or a group of cells it colors those cells a light blue color. The blue is to light and I would like to darken it. Is that possible and where do I go to do it.

    This may be a very simple question, but I have looked everywhere I can think to look to try and make this change.
    Last edited by boylejob; 08-05-2010 at 01:03 AM.
    Sincerely,
    Jeff

  2. #2
    Forum Contributor
    Join Date
    04-07-2009
    Location
    Rowley
    MS-Off Ver
    Excel 2007
    Posts
    326

    Re: Selected Cell Highlighting

    Not sure this will work in Excel 2007 but
    Excel 2000 uses the color scheme from your system preferences, so to change it:

    Select: Start,
    Select: Control Panel
    Select: Display

    Select: Appearance Tab
    Select: Advance Button

    In the “Item:” drop down box
    Click on: Selected Items

    Change the color to what you want.

    Just be aware that this will change it for ALL your applications.

  3. #3
    Forum Contributor boylejob's Avatar
    Join Date
    02-22-2007
    Location
    Forest City, NC
    MS-Off Ver
    2003
    Posts
    562

    Re: Selected Cell Highlighting

    xenixman,

    I thought about that and gave it a try, but it did not change anything. I am currently using a similar idea by changing the Window to a light shade of gray. This is not the ultimate solution because now everything has a background that is light gray, but at least I can select a column, do a search, and see where the item was found.

    Thanks for responding.

  4. #4
    Forum Contributor
    Join Date
    04-07-2009
    Location
    Rowley
    MS-Off Ver
    Excel 2007
    Posts
    326

    Re: Selected Cell Highlighting

    I thought about that and gave it a try, but it did not change anything
    It worked on my XP box, but I could not find a way to do it under Vista.

    I just checked my sons 2007 version,
    The only thing that I can suggest is you change the gridline colors.

    This is under Excel Options
    Advanced

    About 3/4 of the way down, under the heading:

    Display Options for this Worksheet

    Change it to Black or perhaps Dark Blue.
    Last edited by xenixman; 08-05-2010 at 04:08 PM. Reason: added commet

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1