Displaying Negative %

J

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,
 
B

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

--
 
M

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
 
Top