Skip to main content
Get Started
Documentation

Conditional formatting in Tractorscope table charts

Conditional formatting makes table charts easier to scan by highlighting values that meet specific conditions.

Common uses

  • Highlight overdue tasks
  • Mark failed statuses
  • Emphasize high-value customers
  • Flag values above or below a threshold
  • Call attention to exceptions

SQL and formatting

SQL should return the values you need to display. Conditional formatting handles how those values appear in the table.
select
  customer_name,
  balance_due,
  status
from invoices
where status in ('open', 'overdue')
select
  customer_name,
  balance_due,
  status
from invoices
where status in ('open', 'overdue')

Tips

  • Use formatting to improve scanning, not to replace clear labels.
  • Keep colors consistent with dashboard meaning.
  • Combine with data bars for numeric comparisons.

Related docs