J.E. McGimpsey has a routine that does this with pictures.

Maybe you could modify it to do what you want:
http://www.mcgimpsey.com/excel/lookuppics.html

ToledoMichael wrote:

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,

--

Dave Peterson