Use a Custom Format of: 0%;[Red]-0%
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Jason" wrote in message
...
I don't see a way to make a negative percentage (-29%) show up in red.
Do I have to use conditonal formatting, or is there an easier way?