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