#1 is basic indeed:
You'll see the effect of the absolute address (with $$) if you drag this formula down to b3 and below with the copy handle.
#2 is a little bit more difficult. I don't have Office 2007 (or even 2003), so I'll give you the term to look for in the Help: conditional formatting, with a formula as criterion.
For example: I can define a conditional format for B4, with the following contents:
if =b4<b3 then red
if =b4=b3 then black
if =b4>b3 then green
And this also can be dragged down.
Hope this helps.
I am trying to create a financial spreadsheet in Excel 2007, but I am having trouble with basic forumlae.
For one, I want to create a formula that will take a stock's value and divide it by the initial price.
Another, I want to have the color of the number change depending upon the color of the preceeding number.
So if I enter in $222 as the first number and I type in $232 in the next cell, I want for excel to automatically make the next number in green (or red, depending on the value).
Thanks for any help.