Excel - Customize & Expand Your Excel Color Palette - Learn How to Add & Modify Colors - Episode 526
1,528 views · Published 21 August 2009 · 2:17 · Indexed 21 October 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: Customize & Expand Your Excel Color Palette - Learn How to Add & Modify Colors. Welcome back to another MrExcel netcast! In today's video, we're going to be discussing the color palette in Excel. This is a topic that I get asked about frequently, and for good reason. In older versions of Excel, we were limited to only 56 colors in the color palette. But fear not, because in this video, I'll show you how to customize and expand your color options. If you're using Excel 97 through 2003, you'll notice that the Fill drop down only has 56 colors to choose from. But did you know that you can actually change these colors to a different set? It's a bit of a tedious process, but it's definitely worth it. You'll need to go to Tools, then Options, and navigate to the color tab. Here, you'll see the palette of 56 colors, as well as additional colors for Chart fills and lines. To change a color, simply click on it and then click on "modify". From here, you can choose from any of the colors in the palette or even enter specific RGB values to create a custom color. This is great for matching your company's logo or branding. However, if you want to customize all 56 colors, you'll have to go through this process multiple times. But don't worry, I'll also show you a quick and easy way to add a few colors for your logo without having to go through the entire palette. In addition to customizing the colors for cells, you can also change the default colors for charts. I've personally changed the default chart colors to match the MrExcel color scheme. This way, every time I create a chart, it automatically uses my custom colors. It's a small detail, but it can make a big difference in the overall look and feel of your charts. So stay tuned for more tips and tricks on color palettes in upcoming videos. Thanks for watching and I'll see you in the next netcast from MrExcel! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction to Excel color palette (00:23) Limitations of 56 colors in Excel 97-2003 (00:44) How to customize color palette (01:01) Using RGB values to create custom colors (01:20) Process of customizing all 56 colors (01:30) Adding a few colors for logo (01:40) Changing default chart colors (01:54) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Adding colors to Excel Changing colors in Excel Chart fills in Excel Chart lines in Excel Creating custom colors in Excel Customizing Excel color scheme Default chart colors in Excel Excel color options Excel color palette Modifying colors in Excel MrExcel netcast on color palettes RGB values in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152576/ Excel 97 through Excel 2003 was limited to 56 colors, but you dont have to keep the 56 colors that Microsoft chose. You can customize the colors for any workbook. Episode 526 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919