I'd like to make numbers <0 green and numbers <0 red

how do i do that?



thanks

Ponk

FormatConditional FormattingCell value is: less than 0, format to green.

Add and under Condition2 Cell value is greater than 0, format to red.

I am assuming a typo in your original post where you have both <0


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 07:48:47 +0800, "Ponk" wrote:

I'd like to make numbers <0 green and numbers <0 red

how do i do that?



thanks

Yep that was a typo.

thanks!

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Ponk

FormatConditional FormattingCell value is: less than 0, format to green.

Add and under Condition2 Cell value is greater than 0, format to red.

I am assuming a typo in your original post where you have both <0


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 07:48:47 +0800, "Ponk" wrote:

I'd like to make numbers <0 green and numbers <0 red

how do i do that?



thanks

Conditional formats are better, but a custom format, or custom Style is
another option:

[Red]General;[Green]General;General

.... I'd like to make numbers <0 green and numbers 0 red

--
Dana DeLouis
Win XP & Office 2003


"Ponk" wrote in message ...
I'd like to make numbers <0 green and numbers <0 red

how do i do that?



thanks