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



Spreadsheet with real data: download


Thanks in advance.

 

[zizao]

Kaper found the solution in EXCELFORUM. The solution is on Painting cells whose sum is zero.

 

[RoryA]

This appears to be exactly the same question as this one: http://www.mrexcel.com/forum/excel-...result-equal-zero-color-background-cells.html

Care to explain, please?