G Gord Dibben Mar 30, 2005 #2 Ponk Format>Conditional Formatting>Cell 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
Ponk Format>Conditional Formatting>Cell 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
P Ponk Mar 30, 2005 #3 Yep that was a typo. thanks! Gord Dibben said: Ponk Format>Conditional Formatting>Cell 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 Click to expand...
Yep that was a typo. thanks! Gord Dibben said: Ponk Format>Conditional Formatting>Cell 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 Click to expand...
D Dana DeLouis Mar 30, 2005 #4 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
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
