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

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Hi, I have a multiple choice text field and I would like to colour the text or cell according to its status. So for instance Green for COMPLETE, amber PENDING etc... ?
Photo of Richard Courtenay

Richard Courtenay

  • 70 Points

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
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.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,264 Points 5k badge 2x thumb
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.