Skip to content
palettes
Color Table Utilities
Share
Explore

palettes
Color Table Utilities

Choose your own ways to color table rows
Ever wanted to have some more freedom on row colors? Preset gradients are too few and restricted to numbers only? Here some tricks to expand coloring capabilities!

Read me first!

This document is designed to demonstrate and test the potential capabilities of Coda, rather than to serve as a production template.
It primarily utilizes the unofficial _GRADIENT() formula (within the conditional format section). Please note that this formula has certain limitations and could be subject to changes or discontinuation at any time.
You are encouraged to experiment with it, but please be aware that its use is at your own risk.
This doc is also using a convenient pack () that has been built for this precise purpose. Almost everything could have been done in “pure” Coda, but it would have required a lot of intensive computation.

Examples

[Some basic formula knowledge is required, here]

Are you on dark mode theme? Please, click here:
Dark Mode is: OFF ⚪
(it might take some time to switch)


1. [Easy] For each row, a manual selectable color

This way you can decide a color for each single row. Useful in Lookup tables. Here’s an example:
Status Table
1
Name
Color
1
Not Started
Lavender
2
In Progress
Steel Blue
3
Done
Olive Green
4
Won’t Do
Coral Pink
There are no rows in this table
Add a relation column Color to in your table
In the Conditional format, add a formula-based rule like this (you can copy/paste it) and apply to the columns of your choice
[Optional, but recommended] Still in the Conditional format, add another formula-based rule:
Then, just select a white text (More → Custom → Text Color → White) and apply it to the same columns you chose for the background

2. [Medium] Multi-level: for every row, a shade of a specific color

Useful when you have hierarchies. typically category and sub-category.
There are several variations, here is just one of the possible use-cases:
Taxonomy
1
Name
Parent
Color
2nd Color
1
Mammalia
coral
2
Lion
Mammalia
3
Tiger
Mammalia
4
Bear
Mammalia
5
Wolf
Mammalia
6
Aves
Corvette
7
Sparrow
Aves
8
Eagle
Aves
9
Owl
Aves
10
Actinopterygii
Jungle Mist
11
Goldfish
Actinopterygii
12
Carp
Actinopterygii
13
Shark
Actinopterygii
14
Trout
Actinopterygii
15
Salmon
Actinopterygii
16
Catfish
Actinopterygii
17
Bass
Actinopterygii
There are no rows in this table
Animals
1
Name
Species
Class
1
Richard Parker
Tiger
Mammalia
2
Sam the Eagle
Eagle
Aves
3
Bruce
Shark
Actinopterygii
There are no rows in this table
To achieve this, just start as in the first example, but you define colors only for top level rows
Then you add a custom gradient for children that takes parent’s color as upper bound and 2nd Color (default White) as lower bound.
You can add complexity for multiple nested categories.

3. [Advanced] Tables gradient from a custom palette

Here is where you “bind” a table to an existing palette if you want to have fully custom gradients.
Teams
1
Name
Description
1
Team 1
Description of Team 1
2
Team 2
Description of Team 2
3
Team 3
Description of Team 3
4
Team 4
Description of Team 4
5
Team 5
Description of Team 5
6
Team 6
Description of Team 6
7
Team 7
Description of Team 7
8
Team 8
Description of Team 8
9
Team 9
Description of Team 9
10
Team 10
Description of Team 10
11
Team 11
Description of Team 11
12
Team 12
Description of Team 12
13
Team 13
Description of Team 13
14
Team 14
Description of Team 14
15
Team 15
Description of Team 15
16
Team 16
Description of Team 16
17
Team 17
Description of Team 17
18
Team 18
Description of Team 18
19
Team 19
Description of Team 19
20
Team 20
Description of Team 20
There are no rows in this table
To add a palette-based gradient to any table there are some steps to follow Assuming you have a table “My Table”:
Create a new row in the table (see )
Add the link to My Table (via @-mention)
Select the palette you prefer (and wait for the color-set to be updated)
Add a Gradient Info (formula) column in the destination table.
Click the ‘ Gradient Info button and paste the content in its formula field
Go to conditional formal and add two formula based rules (here it’s similar to the Easy first step, with slightly different formulas)
Click Background Color button, add a formula-based rule, and paste it in the formula field
Similarly, click ‘ Foreground Color button, add a formula-based rule, and paste it in the formula field, then select only a white text for that formula (More → Custom → Text → White)


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.