I have a database which contains the test results for my blood work.
Also included in the data I receive are the normal ranges for each test.
For example, potassium has a normal range of 3.5 to 5.2 What I want to
do is to have three colors when displaying my potassium level. One for
values <3.5, another for values between 3.5 and 5.2, and finally for
values >5.2. The field is a formatted field. How do I change the Format
code for the formatting property to do this?