Excel 2010 color scheme

Topic

New Reply

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.

Reply | Quote

Replies

Some steps to take you part way there . . . http://www.howtogeek.com/howto/18326/change-the-default-color-scheme-in-office-2010/

Reply | Quote

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?

Reply | Quote

Straight from the source: http://support.microsoft.com/kb/288412

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote