Change Color from Defaults

November 18th, 2004 | Categories: Formatting | Tags:
-->

Tired of the default color palette?

oldcolors

Would you prefer some of these choices?

newcolors

If you have Excel 2002 or higher the option is now available to you. Here’s how:

1. Goto Tools
2. Goto Options
3. Select the Color Tab
colortab
4. Click the color you would like to replace in the OLD color palette
5. Click Modify and select your new color, hit OK, OK

Back in your spreadhsheet you will see your newly selected color in place of the old, for instance when choosing a paint bucket color.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
  1. November 19th, 2004 at 07:36
    Reply | Quote | #1

    >>If you have Excel 2002 or higher…

    This capability has been around at least since Excel 97. Also available has been the handy ability to copy palettes from one workbook to another.

  2. Mark
    November 19th, 2004 at 10:36
    Reply | Quote | #2

    Thanks Jon.

  3. CJ
    June 1st, 2010 at 18:24
    Reply | Quote | #3

    Is there a way to set a new color theme as the default in excel so that when I open excel my new color theme is already set without me having to manually change the color theme.

    Thanks