Skip to content
Dynamic Conditional Formatting


Learn how to use the gradient formula to make conditional formatting a breeze, while also giving much more flexibility. Who said you can't have everything?

Conditional Formatting is a great way to color tables, but it turns out there’s a that no one seems to talking about which makes applying conditional formatting to your tables super easy and gives you far greater flexibility with your selection of colors.

Sound too good to be true? Well let’s take a look 😉

Quick Intro. Then onto some demos.
The _GRADIENT() formula accepts a Number column in your table as its first parameter, followed by what seems to be an unlimited number of Color Stops. Each color stop is a Number followed by a Color. You’ll have seen this kind of behavior already with Color Scales, but the _GRADIENT() formula gives you a ton more control.

thisRow.[Number Column],
0, "#ffffff",
10, "#000000"

For more info, check out , otherwise let’s get into some DEMOS!

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