Thats it! Conditional format set. Didn't occur to me.

Thanks Julie and everyone else for your help.


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