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.
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
- Open the board in Projects.
- In the top toolbar, click the 🎨 Format button.
- The Conditional formatting dialog opens. Click Add rule.
- 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).
- 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).
- Pick the color from the swatch palette.
- 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
Related articles
-
Organize work with Projects & boards
Create boards with groups, tasks and subitems, use columns and Kanban or List views, link tasks to deals and contacts, and automate with recipes.
-
Projects (boards): complete guide
Projects in depth, in 54 chapters: boards, columns, formulas, Kanban, Calendar, Gantt and Workload views, forms, automations, My tasks and dashboard.
-
Column types in boards
Status, date, person, number, formula and more: build boards that fit your process.
-
Kanban and List views
See the same board as draggable columns or as an ordered list, depending on what you need.
-
Recipes (automations) inside boards
Create "when this happens, do that" rules so your board works on its own.