Set a color in conditional format by formula

[Jono_Bouwmeester]

Hi everyone

I know this is an old topic, but just wanted to share in case anyone happened upon this thread. There is in deed a way to dynamically format table rows using a formula. I posted about this last year, including a demo doc with a few methods of implementation.

There’s a hidden formula called _GRADIENT() which allows you to specify HexCodes or utilize Coda’s internal color sets. It’s incredibly useful, and easy to implement. Take a look and feel free to use this in your own docs.

Solved: Conditional Formatting by formula using absolutely ANY color

This is my first post in the community, and I’m super stoked to be giving back a little bit. Hopefully someone will find this useful I discovered a hidden formula last night, and saw that there’s nothing in the Coda documentation or in the Community posts about it, so thought I’d whip up a doc to help explain what I discovered. I’ve certainly been having a ton of fun with it today. The _GRADIENT() formula allows you to apply conditional formatting to tables far easier and with m…