Conditional Row Styles

Style rows based on data conditions — like conditional formatting in spreadsheets. Rules apply colors, bold, italic, and strikethrough to rows that match filter criteria.

How it works

1. Open the Row Styles dialog from the view tab context menu
2. Add a rule with one or more conditions (same operators as filters: equals, not equals, greater than, etc.)
3. Choose a background color from the palette or toggle text styles (bold, italic, strikethrough)
4. Rules are priority-ordered — first matching rule wins

Creating a rule

Each rule has:

• Name — a label for the rule (e.g., "Overdue tasks")
• Conditions — filter criteria using column values and operators
• Condition logic — AND (all conditions must match) or OR (any condition matches)
• Style — background color, bold, italic, strikethrough
• Enabled — toggle rules on/off without deleting them

Priority ordering

Drag rules to reorder them. The first enabled rule whose conditions match a row determines that row's style. Later rules are not evaluated for that row.

Saved with presets

Style rules are stored as part of filter presets:

• Private presets — only you see the styles
• Shared presets — everyone loading the preset sees the same row formatting
• Switching presets automatically applies that preset's style rules

Color palette

Eight predefined M3-compatible pastel backgrounds that work in both light and dark mode:

Color	Hex
Red	#FFEBEE
Orange	#FFF3E0
Yellow	#FFFDE7
Green	#E8F5E9
Blue	#E3F2FD
Purple	#F3E5F5
Teal	#E0F2F1
Grey	#F5F5F5

Selection and hover priority

When a styled row is selected or hovered, the selection/hover styling takes precedence over the conditional style. The conditional style reappears when the row is deselected.

Performance

Style rules are evaluated client-side against loaded rows (100 per page). This means:

• No impact on database queries
• SSE-inserted rows pick up styles immediately
• Evaluation is sub-millisecond even with many rules