Conditional Formatting

This section explains how to set up and apply condition-based formatting to a table.

• Open Conditional Formatting

  • Access it by clicking on “Create new rule” or (Alt+Y).

• Set Rule Title

  • Enter a title for the rule in the Title field.

• Apply To

  • Choose to apply the rule to specific rows or columns in the Apply to field.

• Select Style

  • Choose a style to apply when conditions are met.

• Add Conditions

  • Add conditions using AND or OR operators for multiple conditions.

• Apply or Go Back

  • Click Apply to implement the rule or click the back button to cancel.

• Format Rules

Create and manage rules to visually highlight values based on specific criteria, making it easier to identify important data points.