How do I write a script for + or - results

I need to write a script based on the value of a cell in relationship to another cell....

Example:

Day 1. Money total is $40.50
Day 2. Money total is $45.00. So based on this, the value is +$ 4.50 (results in black)

or it could be this;

Day 1. Money total is $75.00
Day 2. Money total is $73.50. So based on this, the value is -$1.50 (which should be in red)

Any help will be appreciated.

You will need a formula like this to calculate the difference:

= A2 - A1

where I have assumed your Day 1 value is in A1 and the Day 2 value is in A2.

You need to format the cell containing that formula as currency, and there is a pre-defined format to show negative numbers in red.

Hope this helps.

Pete

Pete_UK,

Thanks for the help. It is exactlly what I wanted.

Rich