Can you keep a secret?

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

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

Heroes in a half shell

Name

‎

Mask Color

‎‎

Michelangelo

Orange

Leonardo

Blue

Donatello

Purple

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

⁠

Step-By-Step Instructions

‎‎

Title

Name of Lookup Column

Color Shade

‎‎‎‎‎

Generated Formula

Column 8

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"}')

)

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

Video Guide

⁠

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.

Color

Color Stop

Red

Orange

Yellow

Green

Blue

Purple

Pink

Gray

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

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.