Prev: Increment Value By 1 Each Time Spreadsheet is Opened
Next: Office Password Unlocker
From: OldManEd on 3 Jun 2010 19:12
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

From: Gord Dibben on 3 Jun 2010 20:01
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" <econgleton(a)snet.net> 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

From: OldManEd on 3 Jun 2010 20:24
Does this work in both Excel 2003 and Excel 2007?
OldEd

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:tggg06pfc87k5rk6jugshkksfpcde0041k(a)4ax.com...
> 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" <econgleton(a)snet.net> 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
>
From: FSt1 on 3 Jun 2010 20:31
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
>
> .
>
From: Gord Dibben on 3 Jun 2010 20:42
Yes. Has worked since version 8 which is Excel 97


Gord

On Thu, 3 Jun 2010 20:24:16 -0400, "OldManEd" <econgleton(a)snet.net> wrote:

>Does this work in both Excel 2003 and Excel 2007?
>OldEd
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:tggg06pfc87k5rk6jugshkksfpcde0041k(a)4ax.com...
>> 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" <econgleton(a)snet.net> 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
>>

 |  Next  |  Last
Pages: 1 2
Prev: Increment Value By 1 Each Time Spreadsheet is Opened
Next: Office Password Unlocker