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:46-->
[[File:Conditinal_formatting_line_rules_example_en-US.PNG|link=]] <imagem ilustrando essa regra!--T:58-->
On the example above, three rules were added that modify the row's background color if the condition is true.
<!--T:47-->
[[File:conditinal_formatting_line_rules_example_2_en-US.PNG|link=]] <imagem ilustrando essa regra!--T:59-->
In this example, it was added a rule that applies the bold font to the row.
<!--T:48-->
[[File:conditinal_formatting_column_rules_example_en-US.PNG|link=]] <imagem ilustrando essa regra!--T:60-->Here we are adding three symbols (traffic lights) determined by the values of the columnand apllying in the totals.
<!--T:49-->
[[File:conditinal_formatting_column_rules_example_2_en-US.PNG|link=]] <imagem ilustrando essa regra!--T:61-->In this example, we are adding an alert symbol and applying italics when the values ''Profit'' are below xxxxxx''5,000.00''.
<!--T:54-->
<span style="color: red;">'''Important:'''</span>
<!--T:55-->
* The columns/cells rules have priority over row rules.
<!--T:67-->
'''Applies to'''
<!--T:68-->
[[Table]], [[Cross Table]]
=== Examples of tables with applied rules === <!--T:56-->
<!--T:62-->
[[File:conditinal_formatting_example_en-US.PNG|link=]]
<!--T:63-->
[[File:conditinal_formatting_example_2_en-US.PNG|link=]]
<!--T:64-->
[[File:conditinal_formatting_example_3_en-US.PNG|link=]]
<!--T:66-->
[[File:conditinal_formatting_example_5_en-US.PNG|link=]]
<!--T:57-->