Thank you for your quick response, I believe I'm misinterpreting something, or I'm unable to do this due to the previous formula I have?
I attached 2 screenshots, and posted the formula I input.1 screenshot has what's input and the 2nd with the error message.The error message mentions additional characters beyond the end of the formula, however I've confirmed there are no blank spaces.Thank you for your help.If([Design Variance]>1,"<span style='background-color:red;>"If([Design Variance] & "</span>","<span style='background-color:green;>" & [Design Variance] & "</span>")
Thank you for the clarification with the 2nd field. I interpreted it as a 2nd formula in the field at the time.I attempted to use the formula you gave me in a few different ways based on your original message and received 2 different errors. Here's the copied formula:
If([Design Variance]>1,"<span style='background-color:red;'>" & [Design Variance] & "</span>","<span style='background-color:green;'>" & [Design Variance] & "</span>")I tried it with a Formula-Numeric and received the following error:
I was curious if the term used "span" is intended as a derivative for the max/min for the color I'd like to display, but then I thought it's already referenced in the >1 scenario just before it. If I'm understanding this, span is referring to the color applied to the field. Just to be sure after re-reading your initial segment, I attempted it as a Formula-text field and although it did save the text field simply displayed as shown below.