[calc] How display negative vals. in red?
HP Pavilion, win 10 Used to happen auto.
First time here? Check out the FAQ!
HP Pavilion, win 10 Used to happen auto.
There are predefined currency formats for that. None in the plain "numbers" category.
The full format spec (if you use the manual format codes near the bottom of the dialog) can have 4 sections separated by semicolon. With all 4 in use, the first is for positive values, second for negative, third for zero, and fourth for text. Often you don't need more than positive and negative (zero will then fall back to the format for positive, and text is rendered verbatim).
Colors can be specified by bracketed hex RGB values or color names.
Assuming that you use period (dot) for decimal point: Try 0.00;[red]0.00
Asked: 2020-02-12 20:11:39 +0100
Seen: 38 times
Last updated: Feb 13 '20
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]