AboutBob 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,...)
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
Awards and Honors MVP
Led sessions for the Convergence 2004-2006 seminar on Excel tips & tricks
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.
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.
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
