Example - Compare a Measure to a Set of Thresholds

This example shows how to use conditional formatting to compare a measure to low, medium, and high thresholds, also known as stoplight formatting.

In this example you highlight the revenue level for product types such as audio, phones, and accessories. You show the revenues over 800,000 in green, revenues between 400,000 and 800,000 in amber, and revenues below 400,000 in red.

Here's how to configure this example using the Conditional Formatting dialog.