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=]]
Examples of Rule Settings:
On the example above, three rules were added that modify the row's background color if the condition is true.
[[File:conditinal_formatting_example_3_en-US.PNG|link=]]
[[File:conditinal_formatting_example_5_en-US.PNG|link=]]
__NOTOC__