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.

Next

How to Use Rules in Q

Adding Rules to Project Templates

Caveats and Limitations for Rules

Rules, QScript Macros and When To Use Them