Hi

I have a bunch of data in column A, say they are all numbers being
5,10,15,20,25,30.

I am asking if there is any type of function in Excel where I can write
some kind of formula, and get some of these values highlighted, or in
different text colour.

For Example, I want the formula to add up values in that column to
reach a value, say 45.

So I want excel to either highlight the numbers 30 and 15, 25 and 20.

Does anybody know is this is possible?


--
hbjay
------------------------------------------------------------------------
hbjay's Profile: http://www.excelforum.com/member.php...o&userid=30176
View this thread: http://www.excelforum.com/showthread...hreadid=498603

Do you only want 'pairs' of cells to add up to value X, or do you
want any combination of cells in ColA that sum to X?
Rgds,
ScottO

"hbjay" wrote in
message ...
|
| Hi
|
| I have a bunch of data in column A, say they are all numbers being
| 5,10,15,20,25,30.
|
| I am asking if there is any type of function in Excel where I can
write
| some kind of formula, and get some of these values highlighted, or
in
| different text colour.
|
| For Example, I want the formula to add up values in that column to
| reach a value, say 45.
|
| So I want excel to either highlight the numbers 30 and 15, 25 and
20.
|
| Does anybody know is this is possible?
|
|
| --
| hbjay
| -------------------------------------------------------------------
-----
| hbjay's Profile:
http://www.excelforum.com/member.php...o&userid=30176
| View this thread:
http://www.excelforum.com/showthread...hreadid=498603
|

Hi Scott0

I was after any number of cells adding up to value x. the example i
gave just happened to be in pairs :)

if you have any ideas/tips for me, that would be great


--
hbjay
------------------------------------------------------------------------
hbjay's Profile: http://www.excelforum.com/member.php...o&userid=30176
View this thread: http://www.excelforum.com/showthread...hreadid=498603

Not with built in functions but if you have the add-in solver you can use
this technique

http://tinyurl.com/9suck

--
Regards,

Peo Sjoblom

(No private emails please)


"hbjay" wrote in
message ...

Hi Scott0

I was after any number of cells adding up to value x. the example i
gave just happened to be in pairs :)

if you have any ideas/tips for me, that would be great


--
hbjay
------------------------------------------------------------------------
hbjay's Profile:
http://www.excelforum.com/member.php...o&userid=30176
View this thread: http://www.excelforum.com/showthread...hreadid=498603