Introduction
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:
Method
1. Select your table.
2. To apply the rule, go to Automate > Color Scale in the toolbar.
3. Choose from one of the 2-Color Scale or 3-Color Scale gallery icons to automatically apply this setting to your table. Otherwise, press More Rules to change the default settings.
4. OPTIONAL: If you choose More Rules, update the Statistic (if different from the default).
5. 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.
6. OPTIONAL: Set colors for Minimum and Maximum, and Midpoint and Nets/Sums (if applicable).
7. OPTIONAL: Tick Include row NETs/SUMs and/or Include column NETs/SUMs.
8. Press OK.
9. OPTIONAL: To change the settings, right-click the rule on the Rules tab > Edit Rule.