How Damstra Insights Applies Formatting Rules

You can apply formatting rules to data affected by multiple conditions. The formatting rules are applied sequentially and can cancel out a previously applied rule.

For example, if you define the background row color for orders from Florida to appear green but define the background row color for orders that fall within a certain threshold to appear blue, the result will depend on the order in which you organize your format rules.

In the above example, formatting based on the State condition is applied first, then formatting based on the Actual sales condition overrides that rule.

In the above example, formatting based on the Actual sales condition is applied first, then formatting based on the State condition overrides that rule.

Mix and match rules as needed to achieve the look and feel you want.

Related articles

Using the Conditional Formatting Sidebar 

Configure Conditional Formatting

Using the Conditional Formatting Sidebar – Tables

Using the Conditional Formatting Sidebar – Pivot Tables