This article describes how to go from a standard table with default significant arrows and font colors...
...to a table where the significant cells have symbols added to denote the level of significance based on the Corrected p value:
1. Select your table.
2. In the toolbar go to Automate > Browse Online Library > Modify Cell Content > Add Symbols to Significant Cells.
3. Enter the Corrected p value.
4. Enter the Symbol, e.g. an asterisk or series of characters.
5. Repeat steps 4 and 5 for each threshold you wish to differentiate, e.g. 0.1, 0.05, 0.01.
6. OPTIONAL: Tick Show as confidence to show the confidence levels in the footer instead of the p value thresholds.
7. Set Show Significance to No to remove the significant arrows and colors.
8. Press OK.
Note, it is not possible to align the numbers when this rule is applied (i.e., the numbers will move to the left to accommodate the symbols).
Also, when exported, values with a symbol will be rounded in Excel tables. If exporting an Excel chart, the symbol will be removed, but the footer will remain.
Article is closed for comments.