Changes

Jump to: navigation, search

Conditional Formatting

509 bytes added, 12:18, 4 August 2017
no edit summary
<!--T:46-->
<imagem ilustrando essa regra>[[File:Conditinal_formatting_line_rules_example_en-US.PNG|link=]] 
On the example above, three rules were added that modify the row's background color if the condition is true.
<!--T:47-->
<imagem ilustrando essa regra>[[File:conditinal_formatting_line_rules_example_2_en-US.PNG|link=]] 
In this example, it was added a rule that applies the bold font to the row.
<!--T:48-->
<imagem ilustrando essa regra>[[File:conditinal_formatting_column_rules_example_en-US.PNG|link=]] Here we are adding three symbols (traffic lights) determined by the values of the columnand apllying in the totals.
<!--T:49-->
<imagem ilustrando essa regra>[[File:conditinal_formatting_column_rules_example_2_en-US.PNG|link=]] 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-->
=== Examples of tables with applied rules === <!--T:56-->
[[File:conditinal_formatting_example_en-US.PNG|link=]]
 
[[File:conditinal_formatting_example_2_en-US.PNG|link=]]
 
[[File:conditinal_formatting_example_3_en-US.PNG|link=]]
 
[[File:conditinal_formatting_example_4_en-US.PNG|link=]]
 
[[File:conditinal_formatting_example_5_en-US.PNG|link=]]
<!--T:57-->

Navigation menu