Notion just added one of Excel's best features

Notion has added conditional formatting—specifically “conditional color”—bringing one of Excel’s most familiar productivity tricks into Notion databases. The practical payoff is simple: pages can automatically change background color based on database properties, so overdue work, high-priority items, or “good vs. bad” thresholds stand out instantly without manually updating anything.

The walkthrough starts with a task manager view where items due today are mixed with overdue tasks. By opening the view’s settings and creating a new conditional color rule, the system lets users choose a database property (like a due date), set a condition (“date is before today”), and apply a background color (red for overdue). The result is visual separation inside the same view—overdue tasks become unmistakable at a glance, while tasks due today remain in their default styling.

From there, conditional color expands beyond simple table layouts. In a gallery-style recipe tracker, the feature works even though conditional formatting in spreadsheets is typically cell-based. Notion’s support across layouts means the same rule logic can highlight cards in board, gallery, and other view types. A favorite-recipes example uses a checkbox (boolean) property: when “favorite” is checked, the recipe card background turns yellow, making starred items pop without filtering them out of the gallery.

A third example targets creators. In a content planning system, video performance metrics pulled from the Notion API and the YouTube Data API are used to highlight finished videos with view counts above a threshold (e.g., 500,000). Conditional color then turns those high-performing cards green, making it easier to scan for inspiration and identify what resonated.

The tutorial then gets more advanced with stacked rules. Multiple conditional color rules can be added to the same view—such as red for overdue tasks and yellow for high-priority tasks. If a page matches more than one rule, only the topmost rule’s color applies, preventing messy “blended” colors and keeping the visual logic predictable.

Notion’s conditional color also has boundaries. Layout support is broad, but charts and forms don’t fit the model because they don’t display individual rows. Property support is limited to “simple writable” database properties—directly editable fields like text, numbers, selects, statuses, and checkboxes. Properties like formula, relation, and rollup are not supported for conditional color, even though formulas can be used in database filters. That gap matters in the creator’s expense tracker, where “renewal date” is a formula-derived date; highlighting upcoming renewals would be ideal, but the rule can’t be based on that formula property yet.

Finally, the feature is positioned as “conditional color,” not full conditional formatting. Unlike Excel/Sheets, it only changes background color—no text styling (bold/underline/strike) and no color scales. The creator argues that color scales (gradients like red-to-white-to-green) would be a more valuable next step than extra text formatting, since they provide nuanced feedback rather than a single binary highlight. The overall message: Notion’s conditional color is already useful across many views, but formula-based rules and richer formatting would unlock the same depth people expect from spreadsheets.