Forum Discussion
HI Chayce....I made the adjustments you indicated and all the yellow highlighting went away, but now the statement showing on the form starts at includes the div tags <div.....and is not in red. Here is my formula:
If(
[Indirect Exp Overide] > (0.1 * [Subtotal Applicable Items]),
"<div style='color:red'>Indirect Expenses Override Amount is greater than 10% of the Subtotal Applicable Items amount</div>")
------------------------------
Amy Gosz
------------------------------
What type of field do you have it set as? Can you confirm it's a formula-rich text?
Is there other content in the formula besides this?
------------------------------
Chayce Duncan
------------------------------
- AmyGosz12 years agoQrew Trainee
It is a formula text (not rich text) and there is no other text in the formula box.
------------------------------
Amy Gosz
------------------------------- ChayceDuncan2 years agoQrew Captain
Swap it over to Formula Rich Text to have QB interpret the HTML properly and that should do it.
------------------------------
Chayce Duncan
------------------------------- AmyGosz12 years agoQrew Trainee
Perfect! That did it. Thank you so much for your quick replies!
------------------------------
Amy Gosz
------------------------------