Using Data Cell Colors to Determine Status

Cell colors in data grids indicate additional information about the data. The following table shows the default cell colors in data grids:

Table 4. Default Data Cell Colors

Cell Color	Indication
Off-white	This is an input cell. You can enter or edit data manually.
Light green	This cell allows allocations/derived data.
Orange	Invalid intersection of dimension members. You cannot enter data in invalid cells.
Yellow	Yellow indicates one of these conditions: Data in the cells has been modified but has not yet been saved. The input status is OK, but the status of the adjustment is not OK (CH, CN or TRN). If the status is CN for node level adjustments, you must run Force Calculate Contribution to clear up the adjustment member status.
Beige	This cell contains locked/derived data.
Gray	This is a header cell.
Light gray	This cell has no write or read access/derived data.
Dark green	This cell is read-only.

You cannot perform any actions on cells in invalid dimension intersections. Invalid dimension intersections do not accept data entry because the top parent’s detail members are not used, or restrictions are set for those dimensions. You can set up restrictions for dimensions when you set up members in the metadata file. For example, if you set up the Sales account in the metadata file to accept data entry by customer, the intersection of Sales and None for the Custom dimension is an invalid intersection for data entry.

To determine the data status, you must check both the calculation status and the process level of the data. See Viewing Calculation Status and Viewing Process Level.