How to Highlight Table Cells Above and Below the NET

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

...to a table where you highlight cells a specified percentage above and below the NET:

Requirements

A table.

Please note this requires the Data Stories module or a Displayr license.

1. Select your table.

2. Go to Data > RULES on the object inspector.

3. To apply the rule, select the Plus (+) > Modify Cell Content > Highlight Cells Above and Below NET.

4. Specify the Statistic to use (if different from the default).

5. Select the Threshold (%) for working out the proximity to the NET based on using a ratio of the value divided by the NET value.

6. Select the appropriate colors from the color pickers to represent above and below.

7. Press OK.