Negative Percentages in Excel

  Newuser939 15:28 06 Apr 2009
Locked

When formatting cells in Excel to a "number" format it is possible to choose from several options as to how negative numbers are displayed - one such option is to display them automatically in red. If I have a column which calculates a percentage increase or decrease, is there a way to automatically show a decrease in red? When formatting to percentage, the only option available seems to be the number of decimal places and not how negative percentages are displayed.

  VoG II 17:03 06 Apr 2009

Try a Custom number format:

0.00%;[Red]0.00%

  Newuser939 17:12 06 Apr 2009

Thank you for that pointer. Changing it just slightly to
0.00%;[Red]-0.00%
(ie adding the extra minus sign) did the trick.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone