formula for sorting min to max

[belimbor]

Hi there

I have data with loans, its percentage for example: 10%, 15%, 20% etc and values for each percent. I need formula or macro, which will highlight values with minimal percents until concrete sum. For example:


http://s019.radikal.ru/i600/1402/df/438dbafaf4ec.jpg

and concrete sum is 5 000. Than formula will highlight:

http://s019.radikal.ru/i603/1402/29/c2acc48710d2.jpg

the sum of these values is 7490 USD, minimal percent is 10%, then 15%, 15% 17%, 20% and 24%. So values will achieve 5 000 with sum of:

500 USD
150 USD
2 250 USD
1 190 USD
3 400 USD

Thanks for your help and sorry if my need was hard to understand