Using arrows to show increase/decrease by period

[zilla37]

I have searched but still having trouble. What i am looking for is a to have green and red arrows to show if the new totals have either increased or decreased from the previous periods totals.

For ex.

column A1 Period 1 B1 Period 2 C1 Period 3 D1 increase/decrease

A2 - A10 has numbers
B2 - B10 has numbers
C2 - C10 has numbers
D1 - would show a green arrow (pointing up ) if the numbers in period 3 increased compared to period 2. Or a red arrow ( pointing down ) if the numbers in period 3 decrease from the period 2.

Can anyone help please.

 

[Matty]

Which version of Excel are you using?

 

[zilla37]

I am using version excel 2003.

 

[Matty]

With Excel 2007, it's eaiser. Nontheless, see Andy Pope's suggestion here:

http://www.andypope.info/tips/tip011.htm

Matty

 

[zilla37]

I ll take a look.
thanks for the quick reply.

 

[zilla37]

Yes it works.
Thanks for all the help.

 

[Matty]

Yes it works.
Thanks for all the help

Good news! Happy to help.

Matty