Originally Posted by
gls858
Merodoc wrote:
> 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.
>
>
Not sure about the first question but the second can be done with
conditional formating under Format. Pretty self explanatory.
gls858
Bookmarks