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

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



Julie wrote:
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
Contextures
http://www.contextures.com/tiptech.html