I'm trying to have my textbox highlight a row of fields based on what the field's value is. The pseudo-code I'm trying to accomplish:

If FieldA ≤ 12.5 AND FieldA ≥ 9.55, highlight Green.

If FieldA ≤ 9.5 AND FieldA ≥ 6.55, highlight Grey.

If FieldA ≤ 6.5, highlight Yellow.

Since it is a Textbox, I have to use "Formula Is" and this is the calculation I have but doesn't work.

Formula is Case ( FieldA ≤ 12.5 and FieldA ≥ 9.55; "Green";)

What am I doing wrong? Thanks for your help!

Try:

FieldA ≤ 12.5 and FieldA ≥ 9.55

Next, select Fill Color as the format to apply, and choose a green color.

Thank you! It worked.

Thanks it was really helpful.