How do I display negative percentages into red by a formula

M

Mike H

I'm not aware of any way of doing it with a formula but it can be done with
custom formatting

Format|Cells|Custom

#,##0%;[Red]-#,##0%

Mike
 
Top