Hi Mark

also check that some bright spark hasn't put conditional formatting on the
cell - format / conditional formatting

Cheers
JulieD

"Mark" wrote in message
...
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?