Customize cell color based on data state

The Color cells by data state property for views was enhanced to allow customization of cell color based on its data state. You can pick a custom background color for rule-derived cells and read-only cells, and even customize the color of sandbox values. Additionally, the Color cells by data state property has moved and can now be found in the Format manager, under Data area.

Important: The Color cells by data state property overrides any other background color set for the cell.

To enable the Color cells by data state property for a view and customize the background color of cells, follow these steps:

Select a view and click Format manager in the toolbar.
Go to the Data area on the View tab.
Under Table styles, select Color cells by data state and choose the colors you want for Rule-derived background, Read-only background, and Sandbox font.
Click Apply.

Note: Rule-derived cells include cells with rule-derived values, calculations, and set consolidations. The Color cells by data state property does not apply to consolidated members.

Previously, when the Color cells by data state property was enabled, read-only cells displayed in gray, calculated and rule-derived cells displayed in green, and sandbox values in blue font. These were the default settings and could not be changed.