Thread: Coloring cells
View Single Post
  #3  
Old June 4th, 2010, 01:24 AM posted to microsoft.public.excel.misc
OldManEd
external usenet poster
 
Posts: 89
Default Coloring cells

Does this work in both Excel 2003 and Excel 2007?
OldEd

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
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