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

[Robert Großkopf]

Hi Dan,

must be something like

[<3.5][BLUE]0.#;[>5.2][RED]0.#;[Black]0.#

It is depending on the language and the decimalseparator. In German I
have to write comma instead of point.

Regards

Robert
-- 
Homepage: https://www.familiegrosskopf.de/robert

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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

[Dan Lewis]

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+unsubscr...@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