Re: How do I count crossing zero in a column of integers?

Giganews Newsgroups
Subject: Re: How do I count crossing zero in a column of integers?
Posted by:  MartinW (mtmw@hotmail.invalid)
Date: Wed, 31 May 2006

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

Replies

In response to

How do I count crossing zero in a column of integers? posted by Suzie on Tue, 30 May 2006