Previous Topic Next Topic

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 response

Answer 1 / 1
Zephix
Nov 11, 2009 at 03:02 AM
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses