[green] #

[lezawang]

Hi
I did write that custom formatting. Now if I type 100 then 100 will be green. If I type 0 then excel will put nothing in that cell. If I type Hello then excel keep the same text, same black color. So far so good, but when I type -100 excel will change it to Green -100 ?? why is that?? I was expecting excel to leave -100 as black with - sign. Because I did not have anything for negative value? Thank you.

 

[Rick Rothstein]

Hi
I did write that custom formatting. Now if I type 100 then 100 will be green. If I type 0 then excel will put nothing in that cell. If I type Hello then excel keep the same text, same black color. So far so good, but when I type -100 excel will change it to Green -100 ?? why is that?? I was expecting excel to leave -100 as black with - sign. Because I did not have anything for negative value? Thank you.

Show us the Custom Format that you used and tell us what range of values should be turning green.

 

[Eric W]

What custom format are you using?

Try:

[Green]General;General;

 

[lezawang]

Sorry I typed this:

[green]#

my column has these values {100,200,-100,-55,1000,3000}

they all turn green

 

[Rick Rothstein]

my column has these values {100,200,-100,-55,1000,3000}

I know that is what is happening... my question was more along the lines of what should happen. Do you want only positive numbers greater than zero to turn green? If so, and assuming you are only putting integer values in the cell (that is what your attempted Custom Format assumes), then try this custom format pattern...

[Green]#;[Black]#;[Black]0;[Black]@

Any special reason you are using Custom Formatting instead of Conditional Formatting?

 

[lezawang]

Thanks for your reply. No reason why I am using custom formatting. Just trying to experiencing and learn it. But that would lead to this question if I may. When I should use custom vs Conditional formatting?
Thank you once again.

I know that is what is happening... my question was more along the lines of what should happen. Do you want only positive numbers greater than zero to turn green? If so, and assuming you are only putting integer values in the cell (that is what your attempted Custom Format assumes), then try this custom format pattern...

[Green]#;[Black]#;[Black]0;[Black]@

Any special reason you are using Custom Formatting instead of Conditional Formatting?