Can you keep a secret?
Share
Explore
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 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 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!


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.