I understand from looking at past threads that there is a way to
conditionally format a negative percent so that it is red.

But why isn't that a choice automatically provided by Excel?

When you format a cell with a number in it, you are given a choice to format
a negative number in black or red, with or without a parenthesis around the
number.

Why shouldn't you have the option of formatting a negative percentage in
red, with or without parentheses. Red with parentheses is much easier to read
than the thin negative sign to the left in black. At least one should have
the option.

Geoff

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions