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?

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?

Hi Jason,

You can find a full explanation of formatting here.
http://support.microsoft.com/default.aspx?id=264372

HTH
Martin


"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?