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.

Screenshot_110215_063648_PM

 

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