Discussions

Expand all | Collapse all

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

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

    Posted 01-14-2019 18:06
    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


  • 2.  RE: Simply change color of font and/or background in an existing table text or date field

    Posted 01-14-2019 18:51
    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




  • 3.  RE: Simply change color of font and/or background in an existing table text or date field

    Posted 01-14-2019 19:38
    What about just changing the color of the font for a given field, either straight out or based on a cell value or date?


  • 4.  RE: Simply change color of font and/or background in an existing table text or date field

    Posted 01-14-2019 20:22
    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]