Thread: Coloring cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
OldManEd OldManEd is offline
external usenet poster
 
Posts: 11
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