1,438
edits
Changes
no edit summary
<languages/>
<translate>
Sets different formatting (styles) to rows, columns, and cells of normal and intersection tables based on conditions/selections (rules).
These conditions can be a fixed value, a range of values, greater than a certain value, etc.
<!--T:69-->
[[File:mainmenu5.png]]
[[Conditional Formatting Tutorial|See our video tutorial here]]
<!--T:35-->
You will only need to configure the reference column ( the column that is going to be evaluated by the condition) and the condition to apply the rules.
<!--T:36-->
'''Apply on:''' <!--T:71-->The rules for the columns also allow them to be applied to ''Totals'' (total row and total column) and the , ''Others'' row when they are shown in the tablesand Drill down process. <!--T:72-->Be careful when applying the rules in the drill down, because some formatting may not reflect the test applied, especially when they are absolute values. <!--T:70-->[[File:rules-en+US.png|link=]]
<!--T:64-->
[[File:conditinal_formatting_example_3_en-US.PNG|link=]]
<!--T:66-->
