The Formatting band allows the user to change the way a table built in the Table Editor will be displayed in order to highlight important information. The table’s formatting can be determined by a heat map that color codes table cells based on the values within, the values’ deviations from the column’s mean relative to the standard deviation, or an expected range of values.


Heat Map

Clicking this icon sets the background color of table cells in selected columns to display distribution information. The lower a value is the more bright blue its cell will be, whereas higher values will be increasingly yellow. The median value is displayed in a gray cell. Heat maps are useful for quickly noticing trends in data.

To learn more, see:

Heat Maps & Conditional Formatting

Standard Deviation

Clicking this icon sets a table’s formatting using the values’ deviation from the column’s mean. Outliers are highlighted when the table is displayed. This is useful for quickly identifying which of your values appear to follow a certain trend and which do not.

Expected Range

This compares the value to a minimum and maximum defined by name in the preference panel.

For more information about the Table Editor, please see:

Tabular Reports in the Table Editor

Table Column Information

Ribbons and Tabs

Adding Table Columns

Batching in the Table Editor

Table Iteration Options

Menus for a Generated Table

Tables in Layouts

Table Editor Export Options

Plots in the Table Editor

Heat Maps & Conditional Formatting

Table Editor Preferences

Statistics in the Table Editor

Time Series Plots in the Table Editor

Defining Column Formatting in the Table Editor

Keywords and Tables