TotalSheets Theme Colors
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]

© 2020 by TotalSheets.com
Enter the Color for Accent 1
Hue (0-255) 1 2 3 4 5 6 D L
Saturation (0-255)
Luminosity (Brightness) (0-255)
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
Simple Budget Worksheet
Expenses
$1
Mortgage
$1
Printer Ink
$6
Flight Lessons
$9
Snacks
$2
Movies
$19
Total
Savings
Income
$20
Expenses
$19
Total Savings
$1
Color Theme
Sample Subtitle
40
15
23
32
9
34
Sample Graph

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.