A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Coloring cells



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 12:12 AM posted to microsoft.public.excel.misc
OldManEd
external usenet poster
 
Posts: 89
Default Coloring cells

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

  #2  
Old June 4th, 2010, 01:01 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Coloring cells

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


  #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


  #4  
Old June 4th, 2010, 01:31 AM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default Coloring cells

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

"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

.

  #5  
Old June 4th, 2010, 01:42 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Coloring cells

Yes. Has worked since version 8 which is Excel 97


Gord

On Thu, 3 Jun 2010 20:24:16 -0400, "OldManEd" wrote:

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



  #6  
Old June 4th, 2010, 01:44 AM posted to microsoft.public.excel.misc
Jim Cone[_2_]
external usenet poster
 
Posts: 434
Default Coloring cells

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

  #7  
Old June 4th, 2010, 03:20 AM posted to microsoft.public.excel.misc
Black Iccy
external usenet poster
 
Posts: 2
Default Coloring cells

On Thu, 3 Jun 2010 17:31:02 -0700, FSt1
wrote:


but what if the value is zero?? the above doesn't address that.


So, extend the set of definitions.
See the "Add" button?
The one at the bottom of the panel?



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.



  #8  
Old June 4th, 2010, 04:49 AM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default Coloring cells

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


"Black Iccy" wrote:

On Thu, 3 Jun 2010 17:31:02 -0700, FSt1
wrote:


but what if the value is zero?? the above doesn't address that.


So, extend the set of definitions.
See the "Add" button?
The one at the bottom of the panel?



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.



.

  #9  
Old June 4th, 2010, 05:44 AM posted to microsoft.public.excel.misc
Black Iccy
external usenet poster
 
Posts: 2
Default Coloring cells

On Thu, 3 Jun 2010 20:49:01 -0700, FSt1
wrote:

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.


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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.