How to colour text or cell with a multiple choice text field?

Hi Richard,

Typically when a colorized field is needed for reporting purposes this requires the creation of a new Rich Text formua field. The original multiple choice field holds the data for the Status field and the new Rich Text formula holds the instruction on how you would like to colorize that data in the new field. Then you can make use of a formula in the Rich Text field below to give it instructions such as:

Case([Status], "Complete", "<div style='color:#3D9140; '>" & [Status] & "</div>",
"Cancelled", "<div style='color:#EE2C2C; '>" & [Status] & "</div>"
"On Hold", "<div style='color:#FFD700; '>" & [Status] & "</div>", "")

This formula is set up to say if Status is complete then show me Complete in Green, if Cancelled show me Cancelled in red and if On Hold show me On Hold in gold. You would just want to list out each possible Status and then assign it a color by changing the #FFD700 section to the hex color of your choice. I hope this information is helpful Richard.

Here is some help on that topic

https://help.quickbase.com/user-assistance/color_field.html

There is not an equivalent to the Excel Conditional formatting in QuickBase, at present,  so you need to create a new field for this in addition to the real field.