Displaying Negative %

[JohnHill]

I've got a cell that calculates a value as a %. Where the result is a negative value I'd like it to show the figure in Red. Can this be done ?

Thanks,

[Bryan Hessey]

If you set the field as Custom #,##0.00%;[Red]-#,##0.00% it will appear as such, but your calculation would need to allow for the different ( /100 ) figure shown.

Hope this helps

--

I've got a cell that calculates a value as a %. Where the result is a negative value I'd like it to show the figure in Red. Can this be done ?

Thanks,

[MartinW]

Hi John,

You can do that with conditional formatting.
Go to Format>Conditional formatting and set 'Cell value is' 'lower than' 0
and set your format to what you like.
Whole cell Red or font red or perhaps border red.

HTH
Martin