Cell contents visible through AutoShape

[rwleighjr]

Is there a way to make the contents of a cell visible through an AutoShape or a drawn shape that is imported shape from another program? The only option I can find is to have it appear as a sheet background or to make the shape transparent.

I would greatly appreciate any help on this.

 

[Dufus]

rleigh,

My options include "No Fill" for Format Auto Shape... Would that work?

Dufus

 

[rwleighjr]

Thanks but I would like to have the shape have some color, hence "no fill" is not an option. Also, as I foolishly forgot to say before, I would like to have the contents of multiple cells show through.

 

[rwleighjr]

Also, if this might help you in the future, here's a link to a way to display a single value in an AutoShape.

http://j-walk.com/ss/excel/usertips/tip026.htm

Maybe I could just create multiple AutoShapes and put a single value in each.

 

[Dufus]

If you're saying you want a technique similar to the example you posted a link to, try creating a cell in your worksheet that concatenates all the values you want to show in the shape and set the link to that cell.

Dufus