For typical formatting of most tables and cells within, you can use the Appearance tab in the object inspector (or the Chart tab if the table is a specialty table/visualization). For applying color to the table based on a condition or values shown on the table, you will need to apply a table Rule. 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 using a Rule:
Requirements
- A table.
- Familiarity with How to Use Rules in Displayr.
Method
- Select your table.
- Go to Data > Rules > + > Color Scales in the object inspector
.
- 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.
- OPTIONAL: If you choose Custom, update the Statistic (if different from the default).
- 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.
- OPTIONAL: Set colors for Minimum and Maximum, and Midpoint and Nets/Sums (if applicable).
- OPTIONAL: Tick Include row NETs/SUMs and/or Include column NETs/SUMs.
- Press OK.
- OPTIONAL: To change the settings, right-click the rule under the object inspector in Rules > Edit.