fill autoshape color with ref cell conditional formatting

[Julie]

I am creating a scorecard that will use a green/yellow/red signal for targets
met. Is there a way to have the fill color of the shape (a circle)
autopopulate based on the result and conditional formatting of a reference
cell?

 

[Debra Dalgleish]

You can do this with conditional formatting and the Wingding font, as
described here:

http://www.contextures.com/xlCondFormat03.html#Shape