Skip to content
Dynamic Conditional Formatting
Share
Explore

Welcome

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.

Syntax.

_GRADIENT(
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 (
CtrlP
) instead.