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.
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!
When upgrading to Excel 2007, you may wonder how you can convert your older Personal.xls file to something that can be ...
Discover MoreWhen you upgrade to Excel 2007, you may wonder if you also have to upgrade to the new format for your Personal workbook. ...
Discover MoreFlummoxed by the new Excel 2007 interface? You aren't alone, but there is help. Microsoft has made available a handy ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Comments