Thank you Mark. That ended up working to solve my issue. I figured that I had something in the base coding that was throwing it off.
For the complex colors, if I were to tie in a specific field reference and the number range, would that be an additional and statement within the if statement?
For example:
Field 1 = Type (i.e. A, B, C, etc.)
Field 2 = Sensory Score (the measured number)
Type A has a range of 1 - 1.2; Type B has a range of 1.2 - 1.5; etc.
Would the code look something like this:
If(
[Field 1] = C & [Field 2] > 1.5,
"<div style=background-color:Red>" & ToText([Field 2]) & "</div>",
[Field 1] = B & [Field 2] > 1.2,
"<div style=background-color:Blue>" & ToText([Field 2]) & "</div>",
[Field 1] = A & [Field 2] > 1.0,
"<div style=background-color:Yellow>" & ToText([Field 2]) & "</div>",
ToText([Field 2]))
------------------------------
Paige Mann
------------------------------