How do I make the font in a text field red/bold based on a checkbox?
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.
Forum Discussion
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])
The formula would be
IF([Shared]=true, "<font color=red>" & [Facility/Org], [Facility/Org])