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?