Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How To Change The Default Fill Color (All)

    I rarely use the default bright yellow fill color and would like to change this to my usual boring gray. I would have done a search on this topic but as this functionality is not available until we move to a new location, I am posting this query. I couldn't find anything in the Options. Is there a hack to do this? Surely the color can be changed, yes?

    Thanks in advance,
    Brent

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

    Re: How To Change The Default Fill Color (All)

    If I follow your question, the default Fill color is set in Styles; Format, Styles, Normal, Modify, Patterns, select the color you want. I'm not sure but if you use a default workbook or sheet template in your XLStart which has a different setting, you may need to change the Styles in that that template.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How To Change The Default Fill Color (All)

    Brent:

    I don't know of a 'hack' to change the default colour on the Fill Colour Tool. However, you can record a macro (in relative mode) to change cell colour to grey and add this to your toolbar in place of the default button.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: How To Change The Default Fill Color (All)

    You could even add an item to the right-click menu to change the background to gray if you do it alot.

    Steve

Posting Permissions

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