Table Style

The Table Style dialog specifies conditions for automatically changing properties of pivot tables based on specific conditions. For example, you can make all significance values less than 0.05 bold and red. The Table Style dialog can be accessed from the Style Output dialog or from the dialogs for specific statistical procedures.

  • The Table Style dialog can be accessed from the Style Output dialog or from the dialogs for specific statistical procedures.
  • The statistical procedure dialogs that support the Table Style dialog are Bivariate Correlations, Crosstabs, Custom Tables, Descriptives, Frequencies, Logistic Regression, Linear Regression, and Means.

Table. The table or tables to which the conditions apply. When you access this dialog from the Style Output dialog, the only choice is "All applicable tables." When you access this dialog from a statistical procedure dialog, you can select the table type from a list of procedure-specific tables.

Value. The row or column label value that defines the area of the table to search for values that meet the conditions. You can select a value from the list or enter a value. The values in the list are not affected by the output language and apply to numerous variations of the value. The values available in the list depend on the table type.
  • Count. Rows or columns with any of these labels or the equivalent in the current output language: "Frequency", "Count", "N".
  • Mean. Rows or columns with the label "Mean" or the equivalent in the current output language.
  • Median Rows or columns with the label "Median" or the equivalent in the current output language.
  • Percent. Rows or columns with the label "Percent" or the equivalent in the current output language.
  • Residual. Rows or columns with any of these labels or the equivalent in the current output language: "Resid", "Residual", "Std. Residual".
  • Correlation. Rows or columns with any of these labels or the equivalent in the current output language: "Adjusted R Square", "Correlation Coefficient", "Correlations", "Pearson Correlation", "R Square".
  • Significance. Rows or columns with any of these labels or the equivalents in the current output language: "Approx Sig.", "Asymp. Sig (2-sided)", "Exact Sig.", "Exact Sig. (1-sided)", "Exact Sig. (2-sided)", "Sig.", "Sig. (1-tailed)", "Sig. (2-tailed)"
  • All data cells. All data cells are included.

Dimension. Specifies whether to search rows, columns, or both for a label with the specified value.

Condition. Specifies the condition to find. For more information, see the topic Table Style: Condition.

Formatting. Specifies the formatting to apply to the table cells or areas that meet the condition. For more information, see the topic Table Style: Format.

Add. Adds a row to the list.

Duplicate. Duplicates the selected row.

Move Up and Move Down. Moves the selected row up or down in the list. The order can be important since changes specified in subsequent rows can overwrite changes that are specified in previous rows.

Create a report of the conditional styling. Displays a table that summarizes the changes in the Viewer. This option is available when the Table Style dialog is accessed from a statistical procedure dialog. The Style Output dialog has a separate option to create a report.