Microsoft Excel Tutorial: Where are my Excel 2003 Colors? Free Add-In to Bring Back the Colors.
Welcome back to the MrExcel podcast! In this episode, we're discussing Legacy Colors and Excel 2010. Recently, a friend of mine named Don upgraded to Excel 2010 at my suggestion. However, he ran into a problem with the colors not being available in the drop-down menu like they were in Excel 2003. Don was a big fan of these colors and was disappointed to find out they were no longer easily accessible.
After some investigation, I discovered that instead of the 40 colors in Excel 2003, there are now 173 colors in Excel 2010. While this may seem overwhelming, I found a solution to help Don and others who miss the old legacy colors. I created a workbook with all 173 colors mapped out, but quickly realized it was not a practical solution. So, I decided to create an add-in that would make it easier to access these colors.
Introducing the Legacy Color Chooser add-in! This add-in allows you to easily select any of the old legacy colors, change the font or border colors, and even includes the 40 different themes available in Excel 2010. It's a simple and efficient solution for those who prefer the old colors in Excel 2003.
I initially created this add-in for my friend Don, but after he raved about it, I decided to make it available for purchase on our website. It's a small add-in that only took me a Saturday to create, but it can make a big difference for those who miss the old colors. So, if you're a fan of the legacy colors and want an easier way to access them in Excel 2010, be sure to check out the Legacy Color Chooser add-in.
I want to thank Don for bringing this issue to my attention and for sending in countless other questions over the years. And as always, thank you for tuning in to the MrExcel podcast. Be sure to subscribe and stay tuned for more helpful tips and tricks for mastering Excel. See you next time!
Buy Bill Jelen's latest Excel book: [ Ссылка ]
You can help my channel by clicking Like or commenting below: [ Ссылка ]
Table of Contents:
(00:00) Excel 2010 Upgrade and Problem with Legacy Colors
(00:25) Explanation of New Color Options
(00:38) How to Find Specific Colors
(00:53) Step-by-Step Instructions
(01:08) Creating a Workbook for Legacy Colors
(01:36) Alternative Solution: Color Chooser Add-In
(02:00) Features of Color Chooser Add-In
(02:24) Positive Feedback and Decision to Sell Add-In
(03:00) Clicking Like really helps the algorithm
This video answers these common search terms:
Custom colors in Excel
Excel 2003 colors
Excel 2010
Excel color chooser add-in
Excel colors
Excel drop-down colors
Excel themes
Excel tips and tricks
Legacy color chooser website
Legacy colors
MrExcel podcast
Join the MrExcel Message Board discussion about this video at [ Ссылка ]
Ещё видео!