Simple subtraction and color coding ?
 

Can anyone help me? I am trying to do a simple subtraction formula.
will try to explain. I want to take the values of everything in E
through E45 away from the value of E2. The answer to that formula wil
end up in E(Whatever).

The second question is in the conditional area. I want to make it s
that excel will only take numbers displayed in certain colors and pu
them in the correct place. I have two columns, one will be for on
account and another for a differant account. I want to asign a seperat
color to each account and then add values in the rows that are colo
coordinated for a specific value in a column. This value will then b
the one that I mentioned in the first question for the subtractio
formula.

:( :( :( :( :(
I just can't figure it out by myself, I am in need of a friend that ca
help me with this stuff. I am spending to much time racking my hea
trying to figure out the help menue for Microsoft. Might as well be i
Chinese. Ha Ha. :confused

--
needtolear
-----------------------------------------------------------------------
needtolearn's Profile: http://www.excelforum.com/member.php...fo&userid=3145
View this thread: http://www.excelforum.com/showthread.php?threadid=51140