Color Palette Generator for Excel
The Excel color palette
As explained in my article about Theme-Enabled Templates, the color Palette in Microsoft Office makes it a lot easier to create a spreadsheet with decent color schemes. You can also generate your own color theme. We created the tool on this page to aid in the creation of set of theme colors that is based on a single primary color.
This will make it a LOT easier for you to customize your color palette. Simply enter the main color you want to use, and our tool will automatically generate the XML file.
Color Palette Generator [BETA]
Accent 1 -80% -60% -40% +25% +50% |
Accent 2 Text Text Text Text Text |
Accent 3 Text Text Text Text Text |
Accent 4 Text Text Text Text Text |
Accent 5 Text Text Text Text Text |
Accent 6 Text Text Text Text Text |
Dark 2 Text Text Text Text Text |
Light 2 Text Text Text Text Text |
How to Create Your Custom Color Palette
Step 1: Choose a color for Accent 1 that may be based on your brand or just something you think will look great. You can enter the RGB value using RGB(0, 150, 255), the HTML hexidecimal value (such as #557799).
Step 2: Adjust the Saturation and Luminosity to your liking, using the sample graph and budget table to get an idea how the colors will work together.
Step 3: Adjust the Hues of each of the separate Accent colors to your liking. Currently, the color scheme uses Analogous and Complimentary Colors.
Step 4: Download the XML file and store the color theme file in the special "Theme Colors" folder that Excel users to load all custom theme colors (see below).
Note: Typically, the Hue of a color ranges from 1-360 degrees (because it is usually represented in a color wheel), but Excel uses the range 0-255 if you are entering the colors manually using the HSL values.
How to Use the XML File
Excel stores your Color Theme files as separate XML documents inside the program's user settings on your computer. If you need help finding this location, see Customize how Excel Starts at support.office.com. The location of the folder that contains the XML files for Theme Colors may look like this:
C:\Users\username\AppData\Roaming\Microsoft\Templates\Document Themes\Theme Colors
The color theme that you use for a workbook in Excel is saved with that workbook. This means that you can save the current color theme in your workbook as a named color theme and use that theme in other workbooks.
After saving the XML file in this location, when you open Excel, you'll be able to find this color theme listed as an option under Page Layout > Themes > Colors.