Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.

Color Palettes

Microsoft replaced the 56-color palette with Themes in Office 2007, which are generally more difficult for professional users to work with for two reasons: (a) with themes, colors you want to work with are no longer consistently available at the application (e.g., PowerPoint) level, but are instead properties of workbooks, presentations, and documents; and (b) you may only specify up to eight colors in your theme; Microsoft determines the others colors for you—like them or not.

Color Palette

Macabacus overcomes these Office deficiencies with fixed, fully customizable color palettes that are always available in Excel, PowerPoint, and Word. This allows greater consistency in the formatting of models, presentations, and documents produced by you or your organization. These palettes may contain up to 56 colors, and you can create an unlimited number of color palettes to support different business units in your organization. Macabacus palettes are conveniently accessible via button/menu controls on the Macabacus tab for changing font, fill, and border colors.

Macabacus installs with a default 56-color palette, which you should customize to your preferences in the Common Settings dialog accessible from the Macabacus > Settings menu. The Import Colors button lets you customize your color palette quickly. In Excel, set the fill colors of a range of cells as you want them to appear in your palette. The Macabacus palette includes 7 rows and 8 columns, which is the recommended size of this range. Then, select the range and click the Import Colors button. Macabacus will populate the palette based on the fill colors in your selection. The Import Colors feature is not available if the Common Settings dialog was opened in PowerPoint and Word.

Be sure that your palette includes colors used in financial modeling, such as blue for inputs, green for worksheet links, etc. Macabacus color palettes can be shared across your organization using Shared Settings. Macabacus color palettes and Office themes are not mutually exclusive, and may be used in tandem.

This documentation refers to Macabacus version 8.8.4, and may differ from the PDF documentation
on your computer that installed with your version of Macabacus.