Description: Highlighting Negative Numbers is a check box --> add one for positive Numbers for example green Steps to Reproduce: 1. Select the cells and choose Format - Cells. 2. On the Numbers tab, select a number format and mark Negative numbers red check box. Click OK. --> Add new Check Box Actual Results: nothing because Enhancement Expected Results: New Check Box Reproducible: Always User Profile Reset: No Additional Info: https://help.libreoffice.org/latest/en-US/text/scalc/guide/cellstyle_minusvalue.html?DbPAR=CALC On the Numbers tab, select a number format and mark Negative numbers red check box. Click OK.
FYI you can achieve this by simply entering the code below in "Format code". [GREEN]0;[RED]-0 Also conditional formatting could be used to achieve the same result. I'm not sure about adding a new check box in the UI.
Let's see what the UX/design team thinks.
Negative numbers in red is a typical use case for finance. Missing your use case that requires numbers in red for positive value,. And I doubt there is one, generalizable, so Rafael's advice (easy to get from the Format Code line) is the recommended way to format. Besides, you can always use conditional formatting.
(In reply to Heiko Tietze from comment #3) > Missing your use > case that requires numbers in red for positive value Just noting that OP was asking for positive numbers in green. But I also think that workarounds available are sufficient.