AnsweredAssumed Answered

field / text formatting dependent on several criteria

Question asked by Christylouise on Dec 7, 2015
Latest reply on Dec 7, 2015 by beverly

I have a field which contains a number n.

If n is outside a specific range then I currently use conditional formatting to automatically change the colour of n from black to red which I’m happy with.

However, other factors may determine the correct range, for example. An individual about whom I am collecting data has a test result, n. n is within the normal range unless that individual is <12yrs old and/or female.


How can I conditionally format that n field to reflect the various criteria?


Thanks in advance

Outcomes