Back to basics...
Use a custom number format similar to this:
[Green]#,##0.00;[Red]-#,##0.00
Works in most all versions.
--
Jim Cone
Portland, Oregon USA
Excel add-in: http://tinyurl.com/ExtrasXL





"OldManEd"
wrote in message ...
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