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.

Select your table.
Go to Data > Rules in the object inspector.
To apply the rule, select Plus (+) > Modify Cell Content > Highlight Cells Above and Below NET.
Specify the Statistic to use (if different from the default).
Select the Threshold (%) for working out the proximity to the NET based on using a ratio of the value divided by the NET value.
Select the appropriate colors from the color pickers to represent above and below.
Press OK.