Conditional formatting for cells and rows

Automatically color cells or rows on your board based on rules, so you can spot what's urgent, overdue or blocked at a glance.

Jun 26, 2026

Watch this step in the video · Conditional formatting

Conditional formatting automatically colors a cell or an entire row whenever a condition you define is met. It's the fastest way to make a board talk: overdue tasks in red, high priorities in orange, completed items in green, without scanning column by column.

When to use it

  • Spot what's late, blocked or at risk at a glance.
  • Give visual weight to a priority, a status or a due date.
  • Standardize how the whole team reads the board, with no explanations needed.

Requirements

  • A board in Projects with at least one column to evaluate (status, number, date, text, etc.).
  • Permission to edit the board.

Steps

  1. Open the board in Projects.
  2. In the top toolbar, click the 🎨 Format button.
  3. The Conditional formatting dialog opens. Click Add rule.
  4. Build the rule by reading it as a sentence: When [column] [operator] [value] color [the cell / the row].
    • Column: the column being evaluated (e.g. Status or Due date).
    • Operator: equals, is not, contains, does not contain, greater than, less than, greater or equal, less or equal, before, after, is empty, is not empty.
    • Value: the data to compare against (hidden when the operator is is empty / is not empty).
  5. Choose the scope under color: the cell (colors only that cell; you can pick which column to color) or the row (colors the whole item).
  6. Pick the color from the swatch palette.
  7. Add as many rules as you need and click Save.

Verify it works

When you close the dialog, any cells or rows matching a rule are colored immediately. Change a cell value (for example, move a date into the past) and confirm the color updates on its own.

If it doesn't work

  • Nothing gets colored: make sure the operator fits the column type (don't use greater than on a text column) and that the value exactly matches the status option.
  • The wrong column is colored: in the cell scope, confirm the column to color.
  • Two rules collide: when several rules match, the last matching rule wins; reorder or adjust them to avoid overlaps.

Tips

  • Use the row for priorities or global alerts, and the cell to highlight a single data point without flooding the board with color.
  • Less is more: 3 or 4 rules with clear colors read better than ten near-identical shades.

Related articles

Was this helpful?

Related articles

Message us on WhatsApp