Negative Percentage

Jason · Mar 25, 2008

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?

Bernard Liengme · Mar 25, 2008

Use a Custom Format of: 0%;[Red]-0%
best wishes

MartinW · Mar 25, 2008

Hi Jason,

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

HTH
Martin