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 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

You can edit the cell if there is text of any color or if it is blank. 

Gray Background

Gray background with any text color

Cell is read-only. The color or style of the text may indicate why or see Sheets Overview for a list of possible reasons. 

Blue Background

Blue background with any text color

The cell holds account rollups (totals of child accounts) or time rollups (quarter or fiscal year).  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

You have entered data in this cell, but haven't saved your changes.

green text

Green text with any background color

The data is actuals data. The background color tells you more about the data.  

Bold Text

Bold text with any background color

The data is a total. If you can edit it (only on the web), you'll be prompted to use breakback. 

Italic Text

Italicized text with any background color

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

Red Background

Red background with f(x)? for text.

The formula in this cell has an 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 the cell explorer to find the error. To correct formula errors, sign into your Adaptive instance online and click Sheets from the nav menu.

Red Triangle

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

The cell has a note. 

  • Was this article helpful?