Discussions

Expand all | Collapse all

Color Formula

  • 1.  Color Formula

    Posted 06-10-2020 20:16
    I'm trying to color code a record for a numeric summary being greater than 0.  Here is what I have, but the record color doesn't change.  What am I missing?

    If([# of Meetings]>0, "<font color=blue<b>")

    ------------------------------
    Mike McCartney
    ------------------------------


  • 2.  RE: Color Formula

    Posted 06-10-2020 20:46
    Row colorization  formula do not use HTML.

    They look like this

    If([# of Meetings]>0, "blue")

    Laura Thacker has a nice app here with colors. https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000683

    Many of the color names like yellow or red or pink will work, but some are too intense to be readable, so you can use the hex codes in Laura's app. 

    If([# of Meetings]>0, "#98F5FF")










    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Color Formula

    Posted 06-11-2020 08:29
    Thanks Mark.  Really appreciate you!

    ------------------------------
    Mike McCartney
    ------------------------------