Conditional Formatting lets you color-code a dashboard table so the numbers that matter jump out — flag low scores in red, highlight your top accounts, or shade a whole row when it meets a condition.
Who this is for: Anyone building or editing dashboards in Alta who wants a table to be easier to read at a glance.
Before you start
Conditional Formatting is only available on the Table visualization. If your widget is a chart, switch the visualization type to Table first — the formatting control won't appear on other chart types.
You'll need at least one field in your table to build a condition against.
Add a conditional formatting rule
Open the dashboard widget you want to format and make sure its visualization is set to Table.
In the toolbar, click the Conditional Formatting button (the color-palette icon). Hovering it shows the Conditional Formatting tooltip.
In the popover that opens, click the Add Condition dropdown and choose the field you want the rule to look at.
A condition row appears. Set the comparison using the operator and value controls — for example,
is less than 50oris greater than 1000. Date fields start with the past operator and a default value of90 days ago for 90 days, which you can adjust.Click the color swatch on the left of the row to pick a background color for matching values.
Use the Apply On dropdown to choose where the color lands: Cell (just that field's cell) or Row (the entire row). The default is Cell.
To add more rules, use the Add Condition dropdown again. You can stack several conditions on the same table.
Click Apply to save your formatting and close the popover.
Tips and common pitfalls
Table only. The Conditional Formatting button is hidden unless the visualization type is Table. Don't see the color-palette icon? Switch the widget to a Table.
Cell vs. Row. Use Cell to highlight a single value, or Row when a condition should call attention to the whole record (e.g., shade every row where status is "At risk").
Clearing a rule deletes it. If you remove every filter rule from a condition, that condition is removed entirely. To keep a condition, leave at least one rule in place.
Order matters with overlaps. If multiple rules could color the same cell, review them together so the result is the highlight you expect.
Remember to Apply. Changes take effect once you click Apply — closing the popover without applying won't save the rule.
Related