Change the color using function. Like, turn things red when they are late.

Have you tried taking a look at Conditional Formatting? We use this to change colors based on due dates here at Coda. This is a quick article that might help. Keep us posted!

I believe he was referring to a function being able to do that within the doc itself, i.e., not inside of a table where conditional formatting already exists like you suggested. But I may be wrong?

David, you are correct I was looking to format outside of tables.

Got it! My apologies for misunderstanding. While this doesn’t formally exist, what I might do is use formulas in the document to pull from your tables based on due date so you could have a running list of things that are in and out of date.

I am afraid that the issue is a bit more profound than I first assumed. It is one thing you cannot have colors directly in your doc like #4A4A4A (like you have in slack for example) but it is something else that when I use conditional formating to show the color related to the hex, it is not possibl…

It’s possible with hidden formulas. Check this out: [image] A somewhat of a documentation of hidden formulas [Added mechanics of nested buttons] Developers Central Diferent types of color arguments [Back to index] Different hidden formulas use different format for specif…

Color function in document

Product Feedback

Paul_Danyliuk February 14, 2020, 8:22pm 7

It’s possible with hidden formulas. Check this out:

Topic		Replies	Views
Inline Formula Formatting	2	2058	May 18, 2022
Set a color in conditional format by formula Tips and Hacks	39	18681	April 6, 2022
Solved: Conditional Formatting by formula using absolutely ANY color Tips and Hacks	19	4825	April 30, 2026
Add more colors supported by Google Sheets and other apps, so that can migrate from spreadsheets and other docs :) Product Feedback	3	657	November 28, 2019
Use the _Color() formula in conditional formatting like the _Gradient() formula	2	471	May 21, 2024

Color function in document

Related topics