View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jerry[_23_] Jerry[_23_] is offline
external usenet poster
 
Posts: 3
Default update then move down

Hi,

I am not sure how to word this or I would search more on Google for the
answers before asking.

In my spreadsheet, in Column A I have dollar amounts that I enter daily. A1
is my starting number. I would like a total in column C that stays (moves
down) 1 row under the last number entered in Column A. In Column C, the cell
would display the difference between the last number entered in Column A and
the first number entered in Column A. I guess while I am asking, I would
like the Column C number to be blue or red in color depending if the last
number in Column A is larger or smaller than the first one.

Thanks,
Jerry