This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Where Are My Excel 2003 Colors?
Problem: We always used the orange fill from the third row second column of the Excel 2003 color dropdown. Where is this in Excel now?
Figure 1139 Where is this color in Excel today?
If you liked one of the standard 40 colors in the Excel 2003 dialog, they can be found in Excel today, although it might be difficult to find.
Open one of the color dropdowns. This dropdown now shows the theme colors, plus a few basic colors. Skip those and go to More Colors.
Figure 1140 The old colors are under More Colors.
However, when you get to More Colors, you will find that the good old 40 colors are mixed in with 133 other colors. The tough part is figuring out which one of these colors is the color that you want.
Figure 1141 All of the 40 colors are in here, somewhere.
I’ve created a workbook with forty worksheets. Each worksheet draws a line from the old legacy dialog to the new dialog, so you can find where the color is located.
Figure 1142 You can download this workbook for free.
Download the workbook from http://learnmrexcel.wordpress.com/2010/12/06/legacy-colors-and-excel-2010-podcast-1299/.
For fun, I put in one workbook that draws all 40 lines at once. (I did this with VBA, copying the lines from the other 40 worksheets.) It demonstrates how ridiculous a proposition this is.
Figure 1143 Not really a viable way to choose colors.
This question came from a former co-worker who said that his whole department used this orange and that they were going to roll back from Excel 2010 to Excel 2003 because of this orange. I wrote a tiny little add-in that brought the old legacy color dropdown back to Excel. If you love the old Excel colors, the add-in is available for just $3 from http://www.mrexcel.com/coloraddin2010.html.
Figure 1144 The MrExcel $3 Color add-in brings back the old colors in the original sequence.