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
you can add other criteria in the Conditional Formatting dialog. I suggest you come up with the "rules" (on paper, if you will) and see what is _PRIORITY_ as the dialog will be read from the top down to apply the formatting.