How to Color Comparisons in a Table with a Specific Column

Introduction

This article describes how to go from a table showing Column Comparisons...

...to a table that highlights cells which have a significant relationship to a particular column based on the column letters. In this example, it is highlighting based on the Female column (B):

Method

1. Select your table.

2. In the toolbar go to Automate > Browse Online Library > Significance Testing in Tables > Color Comparisons with Specific Column.

3. Enter the name of column to compare with (Highlight cells significantly higher/lower than).

4. Select the appropriate colors from the Higher and Lower results color pickers.

5. Press OK.

Please note the following:

The rule will replace the column letters with colors when comparing against the target column, but will maintain the letters for other comparisons.
This rule works within the spans of the table, so that if you wish to highlight comparisons with the NET or other column within each of the spans on your table, then this is done automatically.
The Column Comparisons do not test with the NET column(s) by default, and in order to include the NET in the testing you must change the settings according to How to Include the Main NET Column in Column Comparisons.
This rule will not show the appropriate high and low results if Show Redundant Tests is enabled in Statistical Assumptions at the table or project level.