How to Highlight Table Cells Above and Below the NET Values

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 with no completely missing or "NaN" columns or rows.

If you have missing data in the cells of the table, first hide any empty rows or columns. See: How to Hide Empty Rows and Columns in a Table or Visualization

Select your table.
Go to Data > Rules in the object inspector .
To apply the rule, select Plus (+) > Other Color > Highlight Cells Above and Below NET Values.
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.