Conditional formatting automatically changes the color of a visual element when a data value meets a defined threshold. Multiple rules can be added and are evaluated in order.
| Widget Type |
Location |
Affected Element |
| Text (Dynamic) |
General Design |
Text color, icon color |
| Circular (Pie, Doughnut, Radial Bar) |
General Design |
Slice color |
| Radial Gauge |
Axis Design → Pointer |
Pointer color |
| DataGrid |
General Design |
Row or cell background / text color |
| Two-Column List |
General Design |
Row / column text color |
How to Access
The step where conditional formatting is found varies by widget type:
- Text / Circular: General Design step → Conditional Formatting section
- Radial Gauge: Axis Design step → Pointer configuration → Conditional Formatting
- DataGrid: General Design step → Conditional Formatting section
- Two-Column List: General Design step → Conditional Style section
Rule Structure
Each rule consists of the following fields:
| Field |
Description |
| Condition Type |
Numeric (>, <, =, >=, <=) or text (equals, contains, starts with) comparison |
| Operator |
Comparison operator |
| Threshold Value |
Reference value compared against the data value |
| Color |
Color applied when the condition is met (varies by widget type) |
Additional Fields for Text Widgets
| Field |
Description |
| Text Color Override |
Color applied to the KPI value text when the condition is active |
| Icon Color Override |
Color applied to the icon when the condition is active |
Additional Field for DataGrid
| Field |
Description |
| Style Application |
Whether to apply the style to the entire row or only the matching cell |
Tips
- When multiple rules are defined, they are evaluated in order and the first matching rule is applied.
- Typical color coding: green (normal), yellow (warning), red (critical).
- For Radial/Linear Gauge, Range Bands are also available for color coding — use Ranges for static thresholds and Conditional Formatting for dynamic data-based colors.