Excel formula

Closed
Amu - Nov 10, 2009 at 11:03 AM
 Zephix - Nov 11, 2009 at 03:02 AM
Hello,

I want the formula which make the negative answer in "RED" and positive in "LIGHT GREEN" after "ADDING" OR "SUBTRACTING".

1 reply

Just conditionally format your columns for positive and negative numbers.

Another solution is format the cells normally and input a custom format.
[Green]0;[Red]0;0
0