Forum Discussion

AshleyAsante's avatar
AshleyAsante
Qrew Cadet
7 years ago

Adding a field's value to a rich text formula

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?