- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Re: How do I count crossing zero in a column of integers?

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

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

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