Coloring cells

  • Thread starter Thread starter OldManEd
  • Start date Start date
O

OldManEd

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
 
You just need Conditional Formatting.

See help on that subject.


Gord Dibben MS Excel MVP
 
hi
no. conditional formating should do it.
in 2003 for neg numbers
cell value is.... less than......0........pick red
for pos number..
cell value is.... greater than......0........pick green

but what if the value is zero?? the above doesn't address that.
how about......
cell value is.... greater than or equal to......0........pick green
you can format the entire column all a once. not really recommended that you
do the "entire" column, just enough to cover your data.
read up on CF in 07. that i'm not up on yet.

Regards
FSt1
 
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" <[email protected]>
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
 
but what if the value is zero?? the above doesn't address that.
Click to expand...

So, extend the set of definitions.
See the "Add" button?
The one at the bottom of the panel?
 
good point but i prefere to limit the number of CF's as much as possible.
see my suggestion.
i would guess it would be user preference.

Regards
FSt1
 
good point but i prefere to limit the number of CF's as much as possible.
see my suggestion.
i would guess it would be user preference.
Click to expand...

Ummm, but you can only ever set 3 parameters/choices (in Office/Excel 97)
... max .. ever. How much of a limit makes you uncomfortable (rhetorical) -)
Anyway, it fits the OP's requirements I'd guess.
 
Back
Top