Dynamic AutoShape Link

Show the star

Here's a hint that I had forgotten about.

You can tie the result of a cell to an AutoShape.

This displays the value in a more dramatic manner.

1. Create an AutoShape on the Worksheet
   
2. With the shape selected, type an equal sign in the formula bar.
   
3. Enter the address of the linking cell (or click the cell)
   
4. Hit Enter

Thanks to AutomateExcel.com for the reminder.



See all Topics