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

Watch on YouTube

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