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:
Method
- Select your table.
- In the toolbar, go to Automate > Browse Online Library > Modify Cell Content > 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.