1 Reply Latest reply on Dec 7, 2015 6:54 AM by beverly

    field / text formatting dependent on several criteria

    Christylouise

      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