Painting cells whose sum is zero

[zizao]

I'm from Brazil and I need your help to solve a spreadsheet.

I have the following values:



8881.92
-6,735.58
-196546.73
-10,229.00
-6,003.60
-69.60
211,632.56
-2,878.32
-4,856.83
-137.24
-8,031.08



I need to paint the cells whose sum is zero.

Note that 8881.92 + - 6003.60 + - 2878.32 = zero
and - 196,546.73 + 211,632.56 + - 10,229.00 + - 4856.83 = zero


So I need formula or macro to paint those cells whose sum is zero, so:



8881.92
-6,735.58
-196546.73
-10,229.00
-6,003.60
-69.60
211,632.56
-2,878.32
-4,856.83
-137.24
-8,031.08




Thanks in advance.

 

[NBVC]

Please post links to all crosspostings of this topic in other forums.

 

[zizao]

excelguru.ca, excelforum, ozgrid and mrexcel.com

Kaper found the solution in EXCELFORUM. The solution are attached to this message.