Ask Your Question

How to show zero values in red

asked 2018-02-08 21:49:53 +0200

nitmd gravatar image

I have a spreadsheet of various currency values. I want zero values to be formatted in red. Negative values are currently in red, but I can't figure out how to extend that to zero. I looked into conditional formatting and creating styles, and I'm just not understanding how I can accomplish this.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-02-08 22:17:16 +0200

Lupp gravatar image

Create a third section in the 'Numbers' format code, and apply there the same formatting as in the second section, but without the minus sign (if any). The new code section will start with [RED] then.

edit flag offensive delete link more


Thank you. This gives me what I want. I did have to go back and clear a bunch of formatting things that were added somehow but once I found and deleted those additions it looks good.

nitmd gravatar imagenitmd ( 2018-02-10 18:55:15 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-08 21:49:53 +0200

Seen: 221 times

Last updated: Feb 08 '18