Skip to content
Gallery
palettes
Color Table Utilities
Color Table Utilities
Colors
Palette Management
More
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 (
Color Utility
⁠
) 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
all_Colors
⁠
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
Configurations
⁠
table (see
Palette Management
⁠
)
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
Configurations
⁠
‘ 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
Configurations
⁠
‘ Background Color button, add a formula-based rule, and paste it in the formula field
Similarly, click
Configurations
⁠
‘ 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.