Skip to main content
Question

Simply change color of font and/or background in an existing table text or date field

  • January 14, 2019
  • 0 replies
  • 102 views
Nothing fancy (yet!), but just wondering how to make a given existing text or date field a different font and/or background color.  Both currently are just text and date types.  Thx!  Mark
    This topic has been closed for replies.

    Alas, there is no easy way to colorize the background of a cell as yet, like you can do with Excel Conditional formatting

    But you can make a new mirror field and use this method.

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


    • MarkGlevicky
    • Author
    • Registered
    • January 15, 2019
    What about just changing the color of the font for a given field, either straight out or based on a cell value or date?
    Again, you need to make a new Rich Text mirror field.

    for example 

    var text FontColor = 
    Case([Priority],
    "High","<font color=red>",
    "Medium","<font color=blue>",
    "Low","<font color=black>");

    $FontColor & [Priority]


    Terms & ConditionsAccessibility statement