Here' s an example from Tom Oglivy, Microsoft MVP, which uses Excel's Solver function.
In A1:A5 put
The objective is to find which of the above numbers total to 221.11.
1. In B1:B5 put the number 1.
2. In B7 put: =SUMPRODUCT(A1:A5,B1:B5)
(you should get 262.22)
3. Go to Tools menu | Solver.
4. In "Set Target Cell", enter $B$7.
5. "In Equal to", click the "Value of" radio button and enter 221.11.
6. In the "by Changing Cells" box use the mouse to select B1:B5.
7. In "Subject to the Constants" area, click the Add button and then enter:
B1: B5 = Bin
8. Click OK.
Cells B1, B3, B4 should have a 1 in them, cells B2 and B5 will show zero, cell B7 will show 221.11.
After clicking "OK" (step 8 above) the Solver Results dialog box will appear - click OK to keep the results.
Use Conditional Formatting to highlight the numbers in column A that sum to the target value.
1. Select A1.
2. Go to the Format menu | Conditional Formatting.
3. In the "Formula is" box enter "=B1=1" (no quotes)
4. Click the Format button and choose your formatting options.
5. Click OK, OK.
6. Use the Paintbrush to copy the formatting to the rest of the range.
There is a macro solution if you prefer.