ExcelBanter - How do I format a column to show a negative percentage in red?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I format a column to show a negative percentage in red? (https://www.excelbanter.com/excel-discussion-misc-queries/141245-how-do-i-format-column-show-negative-percentage-red.html)

swanny

How do I format a column to show a negative percentage in red?

I would like a negative percentage to show red automatically without having
to manually change the format.

David Biddulph[_2_]

How do I format a column to show a negative percentage in red?

Custom format
0%;[Red]-0%
--
David Biddulph

"swanny" wrote in message
...
I would like a negative percentage to show red automatically without having
to manually change the format.

All times are GMT +1. The time now is 03:54 PM.