Thread: How do I format a column to show a negative percentage in red?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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.


Reply With QuoteReply With Quote