This article describes how to go from a table showing exception testing results via the default Arrows and Font Colors setting...
...to a table that highlights cells based on these colored values and arrows:
Requirements
- A built-in drag-and-drop table.
- Color is based on the results of exception testing (Arrows and/or Font colors), whether or not that is turned on for the table. Compare columns highlighting is not supported.
Method
- Select your table.
- Go to Data > Rules on the object inspector
.
- To apply the rule, select the Plus (+) > Other Color > Color Significant Exception Test Results.
- Select the appropriate colors from the Higher and Lower results color pickers.
- Press OK.
- OPTIONAL: Appearance > Appearance > Significance > No.