Ask Your Question

[calc] How display negative vals. in red?

asked 2020-02-12 20:11:39 +0100

abi gravatar image

HP Pavilion, win 10 Used to happen auto.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-13 08:47:31 +0100

keme gravatar image

updated 2020-02-13 08:48:57 +0100

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

edit flag offensive delete link more


See also the Number Format Codes help.

erAck gravatar imageerAck ( 2020-02-14 16:40:42 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-12 20:11:39 +0100

Seen: 23 times

Last updated: Feb 13