Demo Table
Here’s a demo of how the dynamic conditional formatting works. As you change the Mask Color, the relevant color applies to the Name column. Give it a try! For a really easy-to-use implementation, check out the table below. 💡 There’s also a (badly edited - sorry) Video Guide available (pink button on the right of the CFFG table below)
Conditional Formatting Formula Generator
Here’s a handy table to help you apply Coda’s colors to your tables using dynamic conditional formatting. Follow the step-by-step instructions below (highlighted in orange) or check out the video guide (click the button alongside 👉).
Step-By-Step Instructions
Helper Tables
Here are the tables that run the show in the background...
Coda Colors
This table stores the available Coda Colors. Its intended use is as a Lookup column in your target table, to allow you to select a color to apply to each row. To get started, use the Conditional Formatting Generator table above.
I need extra colors!
Eight colors not enough? Click this button to generate “in-between” color stops automatically.
What’s great is that you won’t have to alter any existing Conditional Formatting rules.