Can you post the full formula and copy it here? The way you have it copied looks like it's a syntax error with using " versus '. I would expect something more like this where the entire string is wrapped in " and then the style is wrapped in '
If(
[Indirect Exp Overide] > (0.1 * [Subtotal Applicable Items]),
"<div style='color:red'>Indirect Expenses Override Amount is greater than 10 percent of the Subtotal Applicable Items amount</div>")
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>")
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?
It is a formula text (not rich text) and there is no other text in the formula box.
Swap it over to Formula Rich Text to have QB interpret the HTML properly and that should do it.
