sum values ​​until you get a result equal to zero and color background cells

[elsg]

I need VBA code to.....
I have (positive and negative) values ​​in the range (A1: A600). I do like to know, what added value is zero?

[TABLE="class: grid, width: 174"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]8.881,92[/TD]
[/TR]
[TR]
[TD="align: right"]-6.735,58[/TD]
[/TR]
[TR]
[TD="align: right"]-196.546,73[/TD]
[/TR]
[TR]
[TD="align: right"]-10.229,00[/TD]
[/TR]
[TR]
[TD="align: right"]-6.003,60[/TD]
[/TR]
[TR]
[TD="align: right"]-69,6[/TD]
[/TR]
[TR]
[TD="align: right"]211.632,56[/TD]
[/TR]
[TR]
[TD="align: right"]-2.878,32[/TD]
[/TR]
[TR]
[TD="align: right"]-4.856,83[/TD]
[/TR]
[TR]
[TD="align: right"]-137,24[/TD]
[/TR]
[TR]
[TD="align: right"]-8.031,08[/TD]
[/TR]
</tbody>[/TABLE]
after knowing what values ​​together (summed) is zero I need to color these cells.
'=A1+A5+A8=Zero
Then A1, A5, A8, must be color background cell.

thanks

 

[elsg]

any ideas?

Thanks!