Thanks Dave

That's Fantastic.
I use conditional formating based on the value of the current month
already, so am not able to use it for the change from last month.

The reason the symbols are used is to indicate whether the result has
improved or worsened from last month up or down & hence the arrow


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=493445