Thread: How do I count crossing zero in a column of integers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW
 
Posts: n/a
Default How do I count crossing zero in a column of integers?
Hi Suzie,

One way is to use conditional formatting. Select your entire row and set
condition 1 If cell value is less than zero format blue
condition 2 If cell value is greater than zero format red

HTH
Martin


Reply With QuoteReply With Quote