In Google Sheets, I can write multiple words in different colors within a single cell, and then filter based on the text color, which makes it easy to search or sort specific entries.
However, in Coda, I couldn’t find a way to filter by color inside a cell. Is there a way to replicate this functionality?
yes this can be done by way of “Conditional Format”.
Can be accessed via Table options, or right click the column you want to colour and select “Format” then “Conditional Format”
Formulas as shown in screenshot or have also a sample doc for your further reference if need be.
hope this helps!
cheers!
Mel
