Coda’s gradient formula supports HTML Colors for color stops. You don’t have to use Hex Values, the standard list of 148 different color names all seem to work just fine. If you’re not familiar with HTML Named Colors, they can be really garish. Use the table on this page to find suitable colors rather than using “Blue” or “Red”.
Here’s an example
_GRADIENT(
thisRow.[Row ID],
1, "Blue",
2, "Red",
3, "Yellow"
)
What are HTML Named Colors?
W3C color names are names assigned by the W3C to specify colors in web pages or files. These names can be used instead of their corresponding hexadecimal value to refer to that color in an HTML file or CSS stylesheet. These names are supported by all modern web browsers and used because it's easier to remember color names than color codes.
Important Caveat!
HTML Named Colors Don’t Transition
If you define colors using HTML Named Colors, they don’t seem to transition when the row’s number column is between two color stops. In , we’ve used HTML Named Colors instead of Hex Values, and rows seem to just “Round Down” to the color stop lower than their Position column. Generator
Let’s generate the Conditional Formatting formula for you:
Copy the below HTML Colors table across to your doc. In your target table, add a new LOOKUP column and choose Custom Hex Values as the table to look up to. Name your new column Color LU. Click the Generate Formula button below Open your target table’s Options panel, click Conditional Format Click Add Rule and select the Formula option. Paste the code in there. You can see a video guide at the bottom of
* Note if you make any changes to the HTML Colors table, you’ll need to regenerate the Conditional Format formula, and update it on the destination table.