Add"$" to rich text field

Question

I am looking to add a "$" to a rich text field as I am actually color coding a numeric field. I have the formula below

If( [Field 1] > 1,
"<span style='background-color: #ffb3b3'>" & Round ([Field 1]),
ToText (Round(([Field 1]))))

------------------------------
D
------------------------------

MarkShnierYou · Answer

try thisIf( [Field 1] > 1,"<span style='background-color: #ffb3b3'>" & "$" & ToText(Round ([Field 1])),"$" & ToText (Round(([Field 1]))))------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community