Formatting Negative %

[Duncan Butterworth]

Is there a way of formatting -(Negative) % so that it is red whilst +(positiive) is still black.
I can do this using conditional formatting but is there a way of formatting a cell to do this.
I an sure this is simple but the answer evades me.
Thanking you in advance.
Duncan

 

[VoG]

Try a Custom format like

0.00%;[red]0.00%

 

[Richard Schollar]

You may want to amend Peter's code to:

0.00%;[red]-0.00%

If you want to retain the minus sign for negative numbers.