Excel Help Needed!!!

H

hbjay

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?
 
S

ScottO

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

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?action=getinfo&userid=30176
| View this thread:
http://www.excelforum.com/showthread.php?threadid=498603
|
 
H

hbjay

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
 
Top