Formatting in table cells options are available under the table setting tab. Below is the image showing where this option can be found.
Once you press the Formatting rules link under Formatting rules menu, the new menu will appear, where you will be required to define your cell formatting rules.
Once you press Create rule button a new menu will appear with all the formatting options.
The editor allows you to create new or edit existing formatting rules. If the cell value satisfies the formatting rule criteria then layout settings you set up below will be applied to that cell.
Cell value can be compared either to fixed number or to values in other columns. When comparing to cells in other columns use ‘Cn’ nomenclature (n = column index (e.g. c1, c2,c5…)) for predetermined column indexes, C1 is the leftmost column. Use C-n (C+n) format to compare cell value to value in cell which is located n columns to the left (right) (e.g. C-1, C-2, C+2…).
Arithmetic operators supported are + (for addition), – (for subtraction), * (for multiplication) and / (for division)
Supported comparison operators are > (larger than), < (smaller than), = (equal to) and <> (different than). Multiple conditions can be chained (combined) using “AND” and “OR” keywords. Formatting is based on rounded values (the values shown in the cells). If a value fulfils the criteria in multiple rules the first one will be applied.
Some examples of formatting rules are listed below:
Formats the cell if the value is greater than 90
Formats the cell if the value is greater or equal to 90
Formats the cell if the value is greater than the value in the column on the most left side
Formats the cell if the value is greater than or equal to the value in the column on the most left side
Formats the cell if the value is greater than the value in previous column
X>=C-1-5 AND X<=C-1+5
Formats the cell if cell value is within +-5 compared to the value in previous column
X>=C-1*0.95 AND X<=C-1*1.05
Formats the cell if cell value is within +-5% compared to previous column
Note: The image below shows the new Formatting rule option in a Sub series. If the check box is ticked theFormatting rules from the Main series are applied, if the check box is un-ticked specific Formatting rules can be setup that only are applied to the current Sub series.
Note: formatting rules won't be applied directly after you are opening a template, because variables aren't saved in the template.
With formatting rules you can replace the value with a text, or pipe in the value in a text.
The Text option in Formatting rule setup is shown in the image below. To replace the value with a text enter the text in the input box, to insert the value in the text insert “[VALUE]” where the value should be shown, example: Your result is [VALUE], which is above target result
The format of the text follows the format of the value. You can apply both the Text and the Style option at the same time in a Formatting rule as shown in the example setup below.
Here we see the setup of Formatting rules, the new Text option is highlighted.