Can you bind an Excel 2010 Ready-made shape from the "Shapes" section to a Cell?

I am working with charts that I want to assign green, yellow, or red shapes based on a formula that checks to see if the number in a particular cell is improved, worse, or the same compared to another cell. So I would like to assign a green star, yellow triangle, or red octagon to a YTD Status?? Is it possible pick the shape and put it into a cell on my data sheet and then reference that cell in my formulas so that it populates that shape???? I have made it work using a ready-made symbol from the Symbols section but I can't get the Shapes to work. Help!!! Thank you!

Thank you Andy - I will try to decifer this and test it out!

yeah.........well, so far no luck in making it work?? Not sure what I am missing! Sorry I am making this difficult for you - I could attach my excel file for you to look at?

Andy -

I will send it after lunch sir. In about an hour.

Andy - ok, included is an example of the matrix I am working with or very similiar. There is a main page (2013) and a Data page that currently has a selection of shapes/symbols that I was trying to make work. Column A has both stock symbols and custom "shapes" that I set in the cells. Column B has stock symbols that I have color and size enhanced and would love to use those as my permanent symbols. I have also created copies on the main page of those symbols as well trying to see if it was a problem with going sheet to sheet for containing the formatting. I had no luck from either spot. Row 7 has the formula in it for the YTD Status Column cell - current green stars (which are not generated by formula they are manually put there based on numbers) which pulls the correct shape (see cell below it) but I had to manually format it to look correct. Row 10 is what it looks like when the formula pulls it in. Row 34 has an manual octagon shape that I am changing to the formula imported pentagon (this one too works but only pulls in unformatted shape - I manually assigned a conditional format style to it) and Row 174 has has the last shape I want but only pulls the unformatted shape. I figured the checkmark, isosceles triangle, and homeplate pentagon would work better than my other shapes in column A because they are symbols and can be directly assinged to a cell....we just need to figure out how to carry the color/size formatting with it in the formula solution. Thank you for looking at this!