Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlighting Color

    When I highlight a range of cells the color of the highlighted cells is mauve. How do do I change this default color? I'm sure this is bound to improve my productivity! Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting Color

    I think that color is controlled by the color scheme selected in the Control Panel, Display Applet on the Appearance Tab. In the "Item" combo box change the color for "Selected Item".
    Legare Coleman

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting Color

    I think you are talking about the cell fill colour.
    Easiest thing is to get the colour picker on your toolbar:
    1] Right click on toolbar
    2] Customize | Commands | Format
    3] Find the Fill button and drag onto a toolbar
    HTH
    Attached Images Attached Images
    • File Type: gif x.gif (1.9 KB, 2 views)

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting Color

    Leif, not that one. What I'm after is the the following. Suppose I want to highlight a range of cells to copy, say. At the mo the highlighted cells change color to black (or mauve on another computer I use). I want to control this color, say change the highlighted color to green. This is only a temporary color whilst the cells are highlighted for copying or cutting etc.

  5. #5
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting Color

    OK - I think you probably mean 'select' rather than 'highlight' ?
    Have a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=36752&page=0&view =expanded&sb=5>this thread</A> on conditional formatting - it may give you some ideas.

  6. #6
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting Color

    Nope, it's not conditional formatting. I just want the selected cells to change color as I'm running the cursor across them whist defining the range for e.g. cutting or deleting.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Highlighting Color

    Hi,
    Legare's answer should be what you're looking for.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting Color

    Ok, perhaps I have mis-understood what he said. How do I get to the control panel? Thanks.

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Highlighting Color

    If you right-click on a blank area of your desktop (i.e. anywhere except on an icon) and choose Properties from the pop-up menu (or do Start-Settings-ControlPanel-Display), you can then select the Appearance tab, choose Selected Item from the Item dropdown list and change it to whatever colour you like. This will however affect your entire windows environment so I'd be careful as to what colour you choose! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting Color

    Ta!

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Highlighting Color

    I tested LeGare's suggestion, and it did not change the display of selected cells on the spreadsheet, which are apparently set only to be the inverse of whatever the fill and border colors are. LeGare's suggestion -did- change selection in menus, drop-down's and about everything else, and I like the results ... but no effect on selected cells in Excel.

    <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Highlighting Color

    Hi John,
    I'm surprised by that - I tested it on mine (O2k on Win2k) and it did change the colour of selected cells. A particularly fetching lime green too!
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Highlighting Color

    Hmm, XL97 on W95. Just re-read Legare's instructions, I -think- I did it right. Ah, well, ghost in the machine.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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