Discussions

Expand all | Collapse all

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

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

    Posted 04-17-2018 14:18
    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... ?


  • 2.  RE: How to colour text or cell with a multiple choice text field?

    Posted 04-17-2018 18:09
    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.


  • 3.  RE: How to colour text or cell with a multiple choice text field?

    Posted 04-17-2018 18:12
    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.