I want to set up a function in Excel where if the value is 1, one auto shape
(an empty ball) is inserted and if a value is 2, then another shape (a shaded
ball) is inserted. Any ideas?

I'm also looking for help in making the shapes (or finding a font to use)
that would need to be inserted. I believe they are called rollerballs and I
need an empty, a full, a half, a quarter, and a three-quarter full ball.

Thanks,