Changes in Excel's Color System

by Allen Wyatt
(last updated March 27, 2017)

2

Don has some complex worksheets that are in their present state after years of development. These worksheets use the classic 40-color palette for fonts, patterns, and borders. When Don opens the workbook in Excel 2007, he noticed right away that the program apparently doesn't use the same colors used in previous versions of Excel and his original well-understood color-coding system is now a horrible mix of all sorts of colors. Don wonders if there a way around this, short of throwing out Excel 2007.

Don is not the only person to have this same question, and for good reason—Excel 2007 has, indeed, abandoned the older 40-color palette and replaced them with color themes. These themes cannot contain as many colors as the old palette, so if you used the old colors extensively, then you may be out of luck.

There is one workaround—you can still use the Format Painter to copy old-version colors to new cells in your worksheet. This means that you could open your legacy worksheet on an older system, copy all your colors to a series of cells in a new worksheet, and then use that worksheet as a "palette" in conjunction with the Format Painter to format your cells in Excel 2007.

This problem (and suggested workaround) is discussed in somewhat more detail at the following page by MVP Bob Umlas:

http://en.allexperts.com/q/Excel-1059/Excel-2007-color-palette-1.htm

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6204) applies to Microsoft Excel 2007.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Converting Codes to Characters

Character codes are the numeric values used, by a computer, to signify various alphanumeric characters. You can use the CHAR ...

Discover More

Should I Leave My Computer On All the Time?

Do you turn your computer on and off all the time? Do you really know if this is good for your computer or not?

Discover More

Accurate Font Sizes

Need to use some bizarre font size in your worksheet? Not a problem, provided it is a full or half point size.

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More ExcelTips (ribbon)

Upgrading Your Personal Workbook

When you upgrade to Excel 2007, you may wonder if you also have to upgrade to the new format for your Personal workbook. The ...

Discover More

Finding Excel 2007 Commands

Flummoxed by the new Excel 2007 interface? You aren't alone, but there is help. Microsoft has made available a handy Excel ...

Discover More

Upgrading Personal.xls to Excel 2007

When upgrading to Excel 2007, you may wonder how you can convert your older Personal.xls file to something that can be used ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 2 + 1?

2013-03-10 14:06:12

Peter Kimberley

I am in despair! I just upgraded to Office 365 so I could read important docx files that a colleague has sent me and I find that Microsoft themes have screwed up literally five years of carefully colour coded work. I now face the prospect of either changing hundreds of spreadsheets or throwing Office 365 in the bin and reverting to Office 2003. I am so angry at Microsoft. Why do they change things so irrevocably. This approach is going to have severe consequences when future generations try to make sense of our published works.


2012-11-01 08:16:57

Paul Seaman

Another approach could be to use Excel styles. Open your workbook in Excel 2007/10, select a cell with a colour you want to keep, and click the Cell Styles button on the Home tab.

Now choose New Cell Style from and name your style (this will help you remember what each colour means). Cell styles also store number formatting, alignment, font, border and protection state. The style will now appear in the cell styles gallery.

The change only affects this workbook, but you can copy these styles to another workbook by switching to the other workbook and choosing Merge Styles from the Cell Style menu.

You could presumably edit the master workbook template so all new workbooks had the required colour styles.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.