Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Cell Colors and Notations Legend

Describes what the cell and text colors and other notations mean in the Adaptive Insights grid of Excel Interface for Planning.

For a table of contents with links to all Excel Interface for Planning articles, go to Using Excel Interface for Planning. For information about cell colors and notations on web sheets, go to Using Sheets > Cell Colors and Notations Legend, which is slightly different.

Cells and the data in cells have different background and text colors, font styles, and triangle notations. This provides quick at-a-glance information about the data. 

What You See What It Means

White Cell

White background with any text color

Edit the cell if there is text of any color or if it is blank. 

Gray Background

Gray background with any text color

Read-only. The color or style of the text may indicate why. See Get to Editable Cells to troubleshoot. 

Blue Background

Blue background with any text color

Rollups (totals) for accounts, time, custom dimensions, and splits. You can't edit these cells in Excel Interface for Planning, but you can edit the cells that roll up to this cell.

Blue Text

Blue text with white or blue background

Unsaved data.

green text

Green text with any background color

Actuals data. The background color tells you more about the data.  

Bold Text

Bold text with any background color

Totals. 

Italic Text

Italicized text with any background color

Has a formula. The background tells you if you can edit or replace the formula. 

Red Background

Red background with f(x)? for text.

Has a formula error. 

To correct formula errors, sign into your Adaptive instance online and click Sheets from the nav menu.

Red Text

Red text with any background color. 

The formula, although correct, is referencing a cell with an error.

Use cell explorer to find the error. To correct formula errors, sign into your Adaptive Insights instance online and click Sheets from the nav menu.

Red Triangle

Red triangle in the corner of cell with any color text or background

Has a note. 

  • Was this article helpful?