Can you keep a secret?
Share
Explore
Can you keep a secret?
Templates

Conditional Formatting

Handy little generator to help give tables some color.

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
Conditional Formatting Formula Generator
⁠
table below.
💡 There’s also a (badly edited - sorry) Video Guide available (pink button on the right of the CFFG table below)
Heroes in a half shell
0
Search
Name
‎
Mask Color
‎‎
1
Michelangelo
​
Orange
​
2
Leonardo
​
Blue
​
3
Donatello
​
Purple
​
4
Raphael
​
Red
​
There are no rows in this table
⁠

⁠

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 👉).

Video Guide
⁠
Add Row
⁠
⁠

Search
Step-By-Step Instructions
‎‎
Title
Name of Lookup Column
Color Shade
‎‎‎‎‎
Generated Formula
Column 8
1
Formula generated!
Copy the "Generated Formula"
(you can use the Copy to clipboard button).
Head back to your target table.
Click on Options then Conditional Format.
Add a Add Rule and select Formula.
Finally, Paste the code you generated and select the columns you wish to apply the color to.
​
Heroes in a half shell demo table
Mask Color
Medium
⁠
Generate Formula
⁠
⁠
_GRADIENT(thisRow.[Mask Color].[Color Stop],
1⁠
, ParseJSON('{"colorId":"Red", "shade":"Medium"}'),
2⁠
, ParseJSON('{"colorId":"Orange", "shade":"Medium"}'),
3⁠
, ParseJSON('{"colorId":"Yellow", "shade":"Medium"}'),
4⁠
, ParseJSON('{"colorId":"Green", "shade":"Medium"}'),
5⁠
, ParseJSON('{"colorId":"Blue", "shade":"Medium"}'),
6⁠
, ParseJSON('{"colorId":"Purple", "shade":"Medium"}'),
7⁠
, ParseJSON('{"colorId":"Pink", "shade":"Medium"}'),
8⁠
, ParseJSON('{"colorId":"Gray", "shade":"Medium"}')
)
​
2
Formula generated!
Copy the "Generated Formula"
(you can use the Copy to clipboard button).
Head back to your target table.
Click on Options then Conditional Format.
Add a Add Rule and select Formula.
Finally, Paste the code you generated and select the columns you wish to apply the color to.
​
This is for the
Variables
⁠
page.
Coda Colors
Light
⁠
Generate Formula
⁠
⁠
_GRADIENT(thisRow.[Coda Colors].[Color Stop],
1⁠
, ParseJSON('{"colorId":"Red", "shade":"Light"}'),
2⁠
, ParseJSON('{"colorId":"Orange", "shade":"Light"}'),
3⁠
, ParseJSON('{"colorId":"Yellow", "shade":"Light"}'),
4⁠
, ParseJSON('{"colorId":"Green", "shade":"Light"}'),
5⁠
, ParseJSON('{"colorId":"Blue", "shade":"Light"}'),
6⁠
, ParseJSON('{"colorId":"Purple", "shade":"Light"}'),
7⁠
, ParseJSON('{"colorId":"Pink", "shade":"Light"}'),
8⁠
, ParseJSON('{"colorId":"Gray", "shade":"Light"}')
)
​
There are no rows in this table
⁠

⁠
Helper Tables
Here are the tables that run the show in the background...
Video Guide
0
⁠

⁠
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.
Search
1
2
3
4
5
6
7
8
Color
Color Stop
Red
1
Orange
2
Yellow
3
Green
4
Blue
5
Purple
6
Pink
7
Gray
8
There are no rows in this table
⁠
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.
⁠
Extra Colors!
⁠
⁠


Gallery
Share
 
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.