By now, youâre likely familiar with the importance of visually displaying data. But sometimes there is so much data to communicate that the most critical parts get lost in translation. Enter: Conditional formatting.
In this article, we will introduce the âNavigating Conditional Formattingâ course in Lucid Training Labs. This course will help you to effectively communicate your data to your team to:
- Emphasize key messages
- Identify process steps
- Call out data information
What is conditional formatting?
Conditional formatting is a feature in Lucidchart that further enables you to unlock the power of visual communication. Using conditional formatting will bring stakeholders together while up-leveling the impact of your diagrams.
Navigating to conditional formatting in Lucidchart
The conditional formatting button is located in the top menu and looks like a magic wand. When you click the wand, select the Create rule button. Drag the window's borders to resize it to a view thatâs easy to see. Rename the default rule by clicking on Rule 1.
To add a new rule, click the + button. To toggle the rule on or off, click the eye icon.
Clicking the top More options button allows you to add a rule to all shapes or add a rule to a few shapes. When you select shapes in your canvas and click Add rule to selection, the rule will only be applied to those shapes.
Clicking the More options button next to a rule youâve created allows you to rename, edit, or duplicate the rule. You can also apply that rule to selected shapes or the entire canvas or delete it.
Lucidchart reads rules from top to bottom, so itâs essential to order your rules similarly. Just drag and drop rules to reorder them.
Using conditional formatting rules
The more information you convey, the more complicated your diagram can become. Conditional formatting rules allow you to better communicate insights in your diagrams so theyâre easier to understand.
Using the âIfâ statementÂ
Say, for instance, you have a large inventory chart and want to know when items are in stock. Setting the data source to âText,â the condition to âContains,â and the value as âIn stockâ means that the rule will be triggered for any âIn stockâ text in your diagram. The rule is case-sensitive, so keep that in mind when setting up your rules.
Using the âThenâ statement
The âthenâ statement is triggered by the âifâ statement to add or make a stylistic change to what youâve determined in the âifâ statement. For example, to add color to your âin stockâ text so it stands out, select Shape style in the formatting drop-down, then choose your colors. You can also add border and line styling. Hit Save to finalize the rule. Ensure youâve selected the shapes you want the rule to apply to.Â
Combining all the rules will result in the text items that are in stock changing to the color you specified so theyâre easy to see.
Duplicating a rule can save time. Use the More options button to replicate a rule. Use the âAndâ statement to combine âIfâ statements.
Reminders
Donât forget:
- Rules are case-sensitive, so if you want the rule to apply to both uppercase and lowercase, create a rule for each.
- You can use rules to apply to spreadsheets. Just upload your spreadsheet and use the conditional formatting rules.
- Donât forget to select the shapes you want the rules to apply to. Otherwise, you wonât see any rules applied to your diagram.
Sign up for the âGain Insight With Conditional Formattingâ course to see demonstrations of conditional formatting and try it out. Conditional formatting is the next step in powerful diagramming.
Â
