custom formatting [green]#

[lezawang]

Hi
If I custom format a cell using >> [green] # << code, if I type 100, I will get 100 in green. If I type -100, I will get -100 in green,, but If I type "Hello", I will get the same Hello. If I type 0, I will get nothing (empty/hide) cell. My question, why 0 is not showing? while the text is showing? I do not have any formatting for Text? I understand the formatting sequence as the following:

Positive number; Negative number, Zero, Text

If I have [green] #

that means I do not have any coding for Zero and Text as well, then why the text did not disappear? only Zero disappeared? to be honest I also think when I type -100, this should not show up because I did not have any formatting for negative numbers as well. but lets focus on the zero and text.

Thank you very much.

 

[Rick Rothstein]

Does it work the way you want if you change the # symbol into a 0 (zero)?

 

[Joe4]

Note that in addition to doing it this way, you can also use Conditional Formatting, i.e.
have a CF rule something like:
=ISNUMBER(A1)
and choose the green font color formattint option.