Discussions

Expand all | Collapse all

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

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

    Posted 08-18-2017 17:13

    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.



  • 2.  RE: How do I make the font in a text field red/bold based on a checkbox?

    Posted 08-18-2017 17:20
    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])


  • 3.  RE: How do I make the font in a text field red/bold based on a checkbox?

    Posted 08-18-2017 18:01

    Thanks Mark.  Your help is always appreciated.