Forum Discussion

DavidSemitekol's avatar
DavidSemitekol
Qrew Trainee
2 years ago
Solved

Color-coding a field returns field name

I have a purchase date field and a second field that is calculating the age based on Today's date.  In a third field I have a rich text field that I'm trying to color-code red if the age is greater th...
  • PranavChoudhary's avatar
    2 years ago
    Use below formula to apply color :

    If([Age Formula]>3,"<div style=\"background-color:red;\">"&[Age Formula]&"</div>",ToText([Age Formula]))


    ------------------------------
    Pranav Choudhary
    Quickbase Expert Builder Certified by Quickbase
    beniwalpranav@gmail.com
    ------------------------------