Color Coding Fields

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
------------------------------