Skip to content
Dynamic Conditional Formatting
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 😉
Then onto some demos.
formula accepts a
in your table as its first parameter, followed by what seems to be an unlimited number of
. Each color stop is a
followed by a
. You’ll have seen this kind of behavior already with Color Scales, but the
formula gives you a ton more control.
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 (