Skip to main content
Question

Adding a field's value to a rich text formula

  • June 29, 2018
  • 0 replies
  • 95 views

I need help with writing a rich text formula. 

I want to say:

if [field A] is not  "yes", show the field's value in #color, if not, show [field A]'s value.

So far I have:



If(

[field A]<> "yes", "<div style=\"background-color:#DADCBD;\"> [field A]- </div>",


[field A])





But for some reason, it's not working. Any ideas on how to get QB to recognize my field's value in the formula?
This topic has been closed for replies.