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

Oliver Harrison

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 n for coloring the cells. A footer note is also added which specifies this condition.