View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
George King
 
Posts: n/a
Default How make the sum red when the sum is minus?

Another way to do this is Conditional Formatting.
Go to 'Format' - 'Conditional formatting' and set criteria for what you want
to do.
--
George


"Janne" wrote:

I want the sum to be red if it's minus and black if it's plus.