You are here:

Excel/Excel 2007 color palette

Advertisement


Rohn wrote at 2007-12-15 08:29:05
Well that is not completely correct.  The old colors are still there, just hard to find.



If you look in the highlighter and font colors drop down dialog you see the (euchy) theme colors, and below that a "palette" of 10 of the old "standard" colors.  Below that there is a "More Colors" button.  That button displays the old "Standard" color wheel and the "Custom" color rainbow.



If you are willing to search for them, the old colors are still there.  But I agree, that creating a worksheet with them and using the format painter may be easier.  



Too bad that M$ didn't bother to create a new "Standard Theme" that used the old standard colors.  You know that themes may be from documents so that they can be shared by the other Office 2007 apps and other people.  Maybe some one  out there will create a theme and upload it to the MS site so others can download it.



PS If you check in Word 2007, you will see that the Highlighter function still uses the old color pallet, while the character color function uses the new themes colors.  So much for application suite consistency.




AltNrg4U wrote at 2007-12-17 12:56:44
Another method might be to save the pallate in the Personal.xls file.  This will open automatically when you open Excel (but I don't believe it works if you open Excel by double clicking a file).  



You would have to find a way to store the pallate as a macro.  I do not know how to do that without a little further research though.  This does have the benefit of opening it from your menu or toolbar though.


King Keepo wrote at 2009-06-01 14:25:07
You could also create a new Theme and set up the old 40 Excel colors, then apply it retrospectively.



You should be able to match colors from the old Excel doc with the color palette of Excel.


Greeman wrote at 2009-07-20 02:44:21
An option is to find out the RGB of the standard 40 colours in Excel 2003, then create a custom "New Cell Style" that enables you to apply the Excel 2003 color as a fill to cells in 2007.


David Loughridge wrote at 2010-01-27 16:05:49
When an old version Excel file is opened in 2007 and you want to continue using the old colors, I found a work around. It's not great, but it does work.



1. Click on the cell with the color you want.

2. Click on the Fill Color button.

3. Select More Colors....

4. Click on the Custom tab.

5. Click OK.



The color will show up on the Fill Color palette under Recent Colors.

It will only stay there as long as the file is open and will not show in other files that are open. Go figure.


Excel Helper wrote at 2010-01-30 01:33:29
Once you start creating workbooks with the Excel 2007 theme based colors, you will run into the opposite problem; where users of previous versions will not see the same colors you do.  Excel converts the new colors back to the 56 color 2003 palette automatically.  



This palette can be modified in Excel 2007 by going to Office Button > Excel Options > Save (option in left sidebar) > Colors… button.  Update the palette with colors used in your 2007 workbook.  This is a tedious process because you have to enter the RGB values for each new theme color.  



The tool from excelcampus.com at the following link automates the entire process and works on multiple workbooks.  There is also a detailed explanation there.



http://excelcampus.com/tools/color-palette-conversion


Jeff wrote at 2010-07-21 18:54:59
Go to Microsoft Button, Excel Options,

Save.

The copy colors from other workbook comes  up when you press the button that says colors.


T00LSMITH wrote at 2010-09-30 18:07:06
Obviously, this isn't really good.  Perhaps someone has made a theme including most of the original 40 colors?  I still hope I can find one.  Of the old 40 color palette, I found myself using the pastels for backgrounds and the bright opaque colors for lettering.  I think I will probably attempt to make a theme using these.  I had little use for the darker colors except black or the very very bright colors.  The existing themes in Office 2007 concentrate too much on "complementary colors".  What I often need is CONTRAST to highlight data.  As usual, Microsoft is one-size-fits-all...  


ericav wrote at 2011-01-29 12:32:14
Here is a useful thread to address this question:



http://forums.techarena.in/ms-office-support/1067716.htm


Etienne Gouws wrote at 2012-11-01 12:49:01
get color index in legacy sheet with

icolor = Range("c5").Interior.ColorIndex





paste color in 2007 sheet

Range("c7").Value = icolor




About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Bob Umlas

Expertise

I`m a Microsoft Excel MVP (Most Valuable Professional) and have been since the inception of the program in 1995. I can answer every kind of Excel question except: API, Importing/exporting to other programs (powerpoint, word,...) Also check out my in-person training link at http://www.thumbtack.com/ny/new-york/excel-training/

Experience

Worked with MS Excel since version 0.99 (on the Mac!). Was contributing editor to Excellence Magazine, having written >300 articles. John Walkenbach said of me "I finally met someone who knows as much about Excel as I do."

Publications
Excellence, The Expert, Microsoft

Education/Credentials
BA in math, Hofstra University, 1965

Awards and Honors
MVP
Led sessions for the Convergence 2004-2006 seminar on Excel tips & tricks

©2016 About.com. All rights reserved.