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