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

How do I show negative percentage in a fomula?	1	Oct 26, 2007
Negative percentage in data verification dropdown list?	2	Dec 10, 2009
Red cell for negative numbers in Excel	1	Mar 14, 2023
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se	2	Mar 3, 2010
Dividing - Negative Number by Zero	5	Aug 23, 2009
Custom cell format for percentage	3	Jul 29, 2008
How do I format a column to show a negative percentage in red?	1	May 2, 2007
Formula Help	2	Mar 29, 2010

Ask a Question