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.

Calculating the values from series that sum to a given value is difficult enough, with the resources to calculate expanding exponentially as the number of terms increases. Obviously, when you have multiple possible number series that can add to that number, the calculation load also increases. But, here's the problem with what you want: What are you going to do about the fact that some of the same values can be part of two or more solutions? For example, you say:
but so does:
Clearly, if there's more than one solution, every solution you find can also be part of another solution.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

Attached Files

Pintar1.xlsm (24.4 KB, 10 views)