The formula you need is (this-month - last-month)/last-month as in
=(B1-A1)/A1
You could then use a custom format such as [Green]0%;[Red]-0% for the
colouring
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Bugalugs" wrote in message
...
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!