You just need Conditional Formatting.

See help on that subject.


Gord Dibben MS Excel MVP

On Thu, 3 Jun 2010 19:12:27 -0400, "OldManEd" wrote:

I have a column of numbers. Some are positive and others are negative. I
would like to color "red" the cell with negative numbers and 'green' the
positive numbers.

Is this possible in either Excel 2007 or Excel 2003? Do I need a macro?
OldEd