This article describes how to go from a standard table...
...to a table with color formatting that transitions from one color to another based on the cell value:
1. Select your table.
2. Go to Properties > RULES on the object inspector.
3. To apply the rule, select the Plus (+) > Color Scale.
4. Choose from one of the 2-Color Scale or 3-Color Scale gallery icons to automatically apply this setting to your table. Otherwise press Custom to change the default settings.
5. OPTIONAL: If you choose Custom, update the Statistic (if different from the default).
6. OPTIONAL: Set the Color Scale type using either a 2 or 3-Color Scale setting. Using a 2 or 3-Color Scale with Values setting allows the user to manually specify Minimum, Maximum and Midpoint (if 3-color scale) values.
7. OPTIONAL: Set colors for Minimum and Maximum, and Midpoint and Nets/Sums (if applicable).
8. OPTIONAL: Tick Include row NETs/SUMs and/or Include column NETs/SUMs.
9. Press OK.
10. OPTIONAL: To change the settings, right-click the rule under RULES in the object inspector > Edit.