ExcelBanter - How do I display negative percentages into red by a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I display negative percentages into red by a formula (https://www.excelbanter.com/excel-worksheet-functions/183906-how-do-i-display-negative-percentages-into-red-formula.html)

Marc

How do I display negative percentages into red by a formula

Is there a formula that can do this???

Mike H

How do I display negative percentages into red by a formula

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

"Marc" wrote:

Is there a formula that can do this???

All times are GMT +1. The time now is 10:24 AM.