mark cells containing a diff

[willwall]

Hello
I want excel to mark the cells that add up to a specific sum, in this case the sum is 1589. What is the best way to do this?
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl65, width: 64"]A[/TD]
[TD="class: xl65, width: 64"]B[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD]Serienr[/TD]
[TD]Belopp[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD="align: right"]1555[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD="align: right"]2555[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD="align: right"]3555[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD="class: xl65"]5[/TD]
[TD="align: right"]4555[/TD]
[TD="align: right"]-900[/TD]
[/TR]
[TR]
[TD="class: xl65"]6[/TD]
[TD="align: right"]6555[/TD]
[TD="align: right"]321[/TD]
[/TR]
[TR]
[TD="class: xl65"]7[/TD]
[TD="align: right"]7555[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD="class: xl65"]8[/TD]
[TD="align: right"]8555[/TD]
[TD="align: right"]418[/TD]
[/TR]
[TR]
[TD="class: xl65"]9[/TD]
[TD="align: right"]9555[/TD]
[TD="align: right"]610[/TD]
[/TR]
[TR]
[TD="class: xl65"]10[/TD]
[TD="align: right"]10555[/TD]
[TD="align: right"]40[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Use Solver.
See this tutorial here: https://www.youtube.com/watch?v=pBZbhvCqX44 (or the many other ones available on the internet).

 

[willwall]

Hello Joe

i looked at the video and it doesnt really work for me as i have too many variables. I have 1500 rows wih numbers. My examble above only shows 10....
Do ypu know another way that allows more variables?