Skip to main content
Question

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

  • August 18, 2017
  • 0 replies
  • 46 views

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.

    This topic has been closed for replies.

    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])
    • RachelMiller
    • Author
    • Registered
    • August 18, 2017

    Thanks Mark.  Your help is always appreciated.


    Terms & ConditionsAccessibility statement