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