Skip to content
Dynamic Conditional Formatting
Share
Explore

icon picker
The Demos

Let's take a look at what's possible...

Custom Colors. Format rows with any color.

By using Hex Values for color stops, you can format your table using any colors you want, not just the ones available in the Conditional Formatting editor. In this example, we map each row on the color lookup table with a color stop.

👀 See the formula



Give it a try! Click the button to add a card with a random color.
Add Card
Turquoise has a Hex Value of #45b5aa
Turquoise
Living Coral has a Hex Value of #ff6f61
Living Coral
Greenery has a Hex Value of #88b04b
Greenery
Fushcia Rose has a Hex Value of #c74375
Fushcia Rose
Marsala has a Hex Value of #964f4c
Marsala
Tangerine Tango has a Hex Value of #dd4124
Tangerine Tango
Mimosa has a Hex Value of #f0c05a
Mimosa
Serenity has a Hex Value of #91a8d0
Serenity
Sand Dollar has a Hex Value of #decdbe
Sand Dollar
Rose Quartz has a Hex Value of #f7cac9
Rose Quartz
Radiant has a Hex Value of #ad5e99
Radiant
Ultimate Grey has a Hex Value of #939597
Ultimate Grey

Hundreds of Rules. Without pulling an all-nighter.

In this example, we have 148 unique colors, one for each of the available HTML Named Colors. You don’t have to use Hex Values, color stops also support HTML named colors like “Blue”, “Red”, “Tomato” or “HotPink”. You can see the named color at the top of each card.
Imagine setting that up in the editor one rule at a time 🤯

👀 See the formula

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.