I am trying to create a stock portfolio data spreadsheet for Excel 2007,
but I am encountering many problems.

Firstly, I am trying to find a formula that will divide the current
value of the stock with the initial price. However, I receive a #Value
error (or some equivalent) whenever I try to enter
=Quotient(G6:G100,F6-F100).

Also, can Excel automatically change the color of the text depending on
the preceeding value? If I enter in $222 in one cell followed by $232 in
the next, can Excel color the numbers red or green depending on
higher/lower?

More later. (If you need further explaining, feel free to PM me.)

I appreciate all help.


--
Merodoc
------------------------------------------------------------------------
Merodoc's Profile: http://www.excelforum.com/member.php...o&userid=37608
View this thread: http://www.excelforum.com/showthread...hreadid=572272