11,677
edits
Changes
Updating to match new version of source page
[[File:mainmenu5.png]]
[[Conditional Formatting Tutorial|See our video tutorial here]]
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.
'''Apply on:''' 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. 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. [[File:rules-en+US.png|link=]]
<span style="color: red;">'''Important:'''</span>
* The last rule has the preference in case two rules modify the same row/column priority (background color, font color, etc).
[[File:conditinal_formatting_example_3_en-US.PNG|link=]]
[[File:conditinal_formatting_example_5_en-US.PNG|link=]]
__NOTOC__