Prev: Calculating 6 days from a date
Next: report by date from a list of records
From: Alan Ralph on 3 Mar 2010 11:16
Hi, I'm looking to calculate the differnce between two numbers, Say I have 24
in a columnand next to it in the next column I have 25, I would like it to
show the differnce of +1 in the next column. Then say the next row down it
has 30 in the first column and 25 in the next it would be a differnce of -5
and so on. Wouls also like the cell to be highted with a colour if its a +
number and a differnt colour if its minus. If both numbers are the same then
would like a 0 and no colour. Hope you can understand what I'm looking for. I
can get it to say true or false but not to show the difference. Hope someone
can help me.
--
Alan
From: Alan Ralph on 3 Mar 2010 11:21
Forgot to say I'm using 2007 edition of Excel.
--
Alan


"Alan Ralph" wrote:

> Hi, I'm looking to calculate the differnce between two numbers, Say I have 24
> in a columnand next to it in the next column I have 25, I would like it to
> show the differnce of +1 in the next column. Then say the next row down it
> has 30 in the first column and 25 in the next it would be a differnce of -5
> and so on. Wouls also like the cell to be highted with a colour if its a +
> number and a differnt colour if its minus. If both numbers are the same then
> would like a 0 and no colour. Hope you can understand what I'm looking for. I
> can get it to say true or false but not to show the difference. Hope someone
> can help me.
> --
> Alan
From: Paul C on 3 Mar 2010 11:24
the formula is simple
A B C
1 24 25 1
2 30 25 -5

In C1 use =B1-A1

Use Conditional Formatting (look in Excel Help for details) to do the colors
Fill with one color if greater than 0, another if less than 0. If the value
is 0 no Fill would be applied
--
If this helps, please remember to click yes.


"Alan Ralph" wrote:

> Hi, I'm looking to calculate the differnce between two numbers, Say I have 24
> in a columnand next to it in the next column I have 25, I would like it to
> show the differnce of +1 in the next column. Then say the next row down it
> has 30 in the first column and 25 in the next it would be a differnce of -5
> and so on. Wouls also like the cell to be highted with a colour if its a +
> number and a differnt colour if its minus. If both numbers are the same then
> would like a 0 and no colour. Hope you can understand what I'm looking for. I
> can get it to say true or false but not to show the difference. Hope someone
> can help me.
> --
> Alan
From: Roger Govier on 3 Mar 2010 11:41
Hi Alan

Supposing we have the data in columns A and B then the formula in C1 is
=B1-A1

You could just format the column, Format>Cells>Number>Red Negative
--
Regards
Roger Govier

Alan Ralph wrote:
> Hi, I'm looking to calculate the differnce between two numbers, Say I have 24
> in a columnand next to it in the next column I have 25, I would like it to
> show the differnce of +1 in the next column. Then say the next row down it
> has 30 in the first column and 25 in the next it would be a differnce of -5
> and so on. Wouls also like the cell to be highted with a colour if its a +
> number and a differnt colour if its minus. If both numbers are the same then
> would like a 0 and no colour. Hope you can understand what I'm looking for. I
> can get it to say true or false but not to show the difference. Hope someone
> can help me.
From: Alan Ralph on 3 Mar 2010 11:51
Thanks Paul I was trying it by difference, you made it so easy I should have
thought of it. done the colour conditioning too thanks again.
--
Alan


"Paul C" wrote:

> the formula is simple
> A B C
> 1 24 25 1
> 2 30 25 -5
>
> In C1 use =B1-A1
>
> Use Conditional Formatting (look in Excel Help for details) to do the colors
> Fill with one color if greater than 0, another if less than 0. If the value
> is 0 no Fill would be applied
> --
> If this helps, please remember to click yes.
>
>
> "Alan Ralph" wrote:
>
> > Hi, I'm looking to calculate the differnce between two numbers, Say I have 24
> > in a columnand next to it in the next column I have 25, I would like it to
> > show the differnce of +1 in the next column. Then say the next row down it
> > has 30 in the first column and 25 in the next it would be a differnce of -5
> > and so on. Wouls also like the cell to be highted with a colour if its a +
> > number and a differnt colour if its minus. If both numbers are the same then
> > would like a 0 and no colour. Hope you can understand what I'm looking for. I
> > can get it to say true or false but not to show the difference. Hope someone
> > can help me.
> > --
> > Alan
 | 
Pages: 1
Prev: Calculating 6 days from a date
Next: report by date from a list of records