If your previous month's value is in A2 and the current month value is
in B2, use

=(B2-A2)/A2

Use the Percent format or, if you want the + sign for positive values,
use a custom number format as "+0%;-0%".

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 16 Dec 2008 09:28:04 -0800, Bugalugs
wrote:

I'm comparing results month on month but want to show it as a percentage - I
think that I'm overly confusing myself but I want to show whether it's a plus
or minus from the month before. It would also be lovely to show plus in
green and minus in red!