How to Change the Color of Table Cells with Small Sample Sizes

Introduction

This article describes how to go from a standard table...

...to a table where columns with a sample size under a specified threshold (e.g. 50) are highlighted:

1. Select your table.

2. In the toolbar go to Automate > Browse Online Library > Modify Cell Content > Change Color of Cells with Small Sample Sizes.

3. Select the appropriate threshold under Minimum Column n.

4. Select the appropriate color from the color picker.

5. Press OK.

Note:

This rule uses the Column Sample Size for coloring the cells. A footnote is also added which specifies this condition.
It will also deal with situations where missing data causes the sample size of each column to vary by row.