Its weird - I can see exactly how it should work and if I use the custom
format

[Black]0%;[Black]-0%;[Black]0%

in different worksheet it works fine. But even if I copy and paste-special
this format to my existing worksheet it still refuses to change from red
when the % is negative.

I'm completely stumped. Any ideas?