I want to change the text color to red if a field value does not fall within the values of two other fields. The values will change with each new document. I have attached an example below. Thanks in advance for the help.
You will need to use conditional formatting on the field where you want to display the changed text colour.
In doing this, you will specify a Condition with Formula is.
The formula will be something like: Self < Accuracy Lo Limit or Self > Accuracy Hi Limit
See how you go with that.
David, Thank you for the help, it worked perfectly!
So please mark his reply as "correct answer" so that we can know your question is answered.
Retrieving data ...