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