Conditional formatting

Conditional formatting applies visual rules to metrics based on their values. Open the ⚙ Chart settings panel → scroll to Conditional formatting at the bottom.

Rule types

Type	What it does	Works on
Highlight	Colours the bar/cell background	Bar, Column, Table
Text colour	Changes text colour in table cells	Table
Reference line	Draws a dashed horizontal line at the threshold	Line, Column, Area
Range band	Shades the area between two values	Line, Area

Adding a rule

1. In the settings panel, find the Conditional formatting section
2. Click + Add rule under the metric you want to format
3. Choose an operator: >, <, ≥, ≤, =, or between
4. Enter a value (or two values for between)
5. Select the rule type (Highlight / Text colour / Reference line / Range band)
6. Click the colour chip to choose a colour

Operators

Operator	Trigger
> (greater than)	Value strictly above threshold
< (less than)	Value strictly below threshold
≥ (greater or equal)	Value at or above threshold
≤ (less or equal)	Value at or below threshold
= (equal to)	Exact match
between	Value falls between two thresholds (inclusive)

Example: traffic light on revenue

Rule 1: total_revenue > 300   → Highlight green  (#1D9E75)
Rule 2: total_revenue < 100   → Highlight red    (#E24B4A)
Rule 3: total_revenue between 100 and 300 → Highlight amber (#EF9F27)

Rules are evaluated in order — the first matching rule wins.

Example: reference line on target

Rule: rental_count = 250 → Reference line (#1B2B5E)

This draws a dashed horizontal line at 250 on the chart, useful for showing a target or budget line.

Persistence

Conditional formatting rules are saved with the scene and travel with pinned tiles.