Thread: How do I display negative percentages into red by a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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???
Reply With QuoteReply With Quote