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?

Jono Bouwmeester

Conditional Formatting is a great way to color tables, but it turns out there’s a

Hidden Formula⁠

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 😉

⁠

Meet Jono⁠

⁠

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

The Formula⁠

, otherwise let’s get into some DEMOS!

⁠

The Demos Let's take a look at what's possible...⁠

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.