[libreoffice-users] Modifying a decimal field in a Base form

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?

Dan


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy