Conditional Formatting
Last updated
Last updated
Conditional formatting is essential for directing users' attention to specific performance areas. It allows you to highlight or emphasize certain records using font styles, borders, icons, text and background colors making it easier to identify important data points.
The data in the table is formatted according to the user-configured rules. This section outlines how to configure and apply condition-based formatting to a table. You can create your own detailed conditional formatting rules from the ground up.
Create Rule: To create a rule, click Format Rules -> Create Rule (Alt+Y). A side panel opens as shown below:
Title: Enter a title for the rule in the Title field.
Apply To: Choose the column to which the formatting should be applied in the Apply to field. If you choose 'Rows', all columns will be formatted for the records that meet the condition.
Style: Using the Style section, you can format text based on color/style, apply a border, or background color, or select icons.
Conditions: In the 'Conditions' section, you can define the conditions using the dropdown options. Based on the type of column (text/numeric) selected, appropriate comparative functions and operators are displayed.
Add Condition: Add multiple conditions by clicking on Add Condition. You can combine them using AND or OR operators.
Apply: Click Apply to implement the rule or click the Back button to cancel.
When you have several conditional formatting rules in your report, you can easily view, modify or delete them using the 'Manage rules' option.
Click on Format Rules -> Manage Rules. A side panel opens and displays all the configured rules.
To add more rules, you can follow the steps explained here or you can click on the Add new rule option.
Let us see some examples.
In this example, we'll format records where the Target Bonus is greater than 0.5. We have applied the following formatting styles to the JobTitle field: bold, fill, font color, and border color where TargetBonus>0.5.
You can apply conditional formatting based on another field in the visual.