[[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.

[[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.

[[File:conditinal_formatting_column_rules_example_en-US.PNG|link=]]

Here we are adding three symbols (traffic lights) determined by the values of the column and apllying in the totals.

[[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 ''Profit'' are below ''5,000.00''.

=== 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=]]