How do I make the font in a text field red/bold based on a checkbox?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I am looking for a formula that would accomplish the following:

If my checkbox field [Shared] is checked display the [Facility/Org] field in bold red.

Photo of Rachel

Rachel

  • 50 Points

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
If the [Facility/Org] is not a formula field, then you will need to make a new formula text field with html enabled checkbox checked,  called perhaps [Facility/Org (color)].

The formula would be

IF([Shared]=true, "<font color=red>" & [Facility/Org], [Facility/Org])
Photo of Rachel

Rachel

  • 50 Points

Thanks Mark.  Your help is always appreciated.