If you have Excel 2007 CF has the up/down/sideways arrows.

If running earlier version you will need VBA

I can send a workbook to your email if you contact me through email at

gorddibbATshawDOTca change the obvious.

Or I can upload the file to a site like savefile.


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 15:06:01 -0700, djbeard83
wrote:

I have a spreadsheet that tracks prices for different commodities
month-to-month that is frequently used for presentations. Each month is
listed in columns and at the last column there are arrows indicating the most
recent trend (red up arrow for increases month over month, green down arrow
for decreases). Currently I have to manually add or delete these shapes
based on which direction prices are moving. Is there a way to use formulas
or conditional formatting to influence objects such as drawn arrows? It
would be easy to do a conditional formatting to change a cell from red to
green based on a formula, but I don't know of any way to conditional format a
shape. Is this possible?