This article describes how to go from a table showing Cell Comparisons via the default Arrows and Font Colors setting...
...to a table that highlights cells based on these colored values and arrows:
Requirements
A table with Arrows and Font Colors via Show Significance > Arrows and Font Colors
Method
- Select your table.
- In the toolbar go to Automate > Browse Online Library > Significance Testing in Tables > Color Significant Cells.
- Select the appropriate colors from the Significantly high and Significantly low color pickers.
- Press OK.
- OPTIONAL: Change Show Significance above table to No.
Technical details
The results shown as significant will match the results shown by Q's standard Cell Comparisons testing, which is indicated by arrows and font colors. To remove the arrows or font colors (or both), make a selection from the Show significance menu above the table.