Results 1 to 6 of 6
  1. #1
    2 Star Lounger bmeacham's Avatar
    Join Date
    Jan 2001
    Location
    Austin, Texas, USA
    Posts
    191
    Thanks
    4
    Thanked 4 Times in 4 Posts

    Excel 2010 color scheme

    I want to use the color scheme from Excel 2003 and earlier in Excel 2010. How can I do that? I just like the earlier colors better.
    Bill Meacham
    bmeacham98 AT yahoo.com

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts
    Some steps to take you part way there . . . http://www.howtogeek.com/howto/18326...n-office-2010/

  3. #3
    2 Star Lounger bmeacham's Avatar
    Join Date
    Jan 2001
    Location
    Austin, Texas, USA
    Posts
    191
    Thanks
    4
    Thanked 4 Times in 4 Posts
    Sorry, what I meant was the color scheme or color palette within an Excel worksheet -- what colors you can use to highlight a cell or a range of cells. They are called "theme colors" in Excel 2010. How can I get a scheme that includes the colors from Excel 2003 and earlier?
    Bill Meacham
    bmeacham98 AT yahoo.com

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts
    Straight from the source: http://support.microsoft.com/kb/288412

  5. #5
    2 Star Lounger bmeacham's Avatar
    Join Date
    Jan 2001
    Location
    Austin, Texas, USA
    Posts
    191
    Thanks
    4
    Thanked 4 Times in 4 Posts
    Thanks, MartinM. That is close, but not exactly what I want. The article you link to tells how to set the palette of an Excel 2010 worksheet when it is opened in an earlier version of Excel. But what I want is that color palette (from the earlier version of Excel) to be the palette that is available in Excel 2010.
    Bill Meacham
    bmeacham98 AT yahoo.com

  6. #6
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts
    Sorry to be so long in replying - but I think I have found a way to do what you want, at last !

    1. In Excel 2010 open the Excel 2003 workbook which has the colours that you want.

    2. Go to the Page Layout tab

    3. Click on the Themes icon on the Themes menu

    4. Click on Save Current Theme, and save it with the extension .thmx

    You can then use this colour theme (scheme) in any Excel 2010 workbook.

    Assuming that this works in the way you want, you can set your chosen theme as the Excel 2010 default by applying it to a blank workbook and then saving that as book.xltx in the XLSTART directory.

Tags for this Thread

Posting Permissions

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