How to enter value in cell and image appears based on value?? PLEASE HELP!

[ishexcel]

hi everyone, I am trying to find out if there is a way to have an image automatically appear in my cell once i enter a value. For example if it enter the number "1" i want a quarter circle to appear in that same cell, if i enter the number "2" then a half circle appears in that cell and so on. I know i can use =IF(G1=1,"quarter",IF(G1=2,"half",IF(G1=3,"threequarter",IF(G1=4,"full","")))) but for this i have to use multiple back end cell and define a name for each one. I just want a quick way to have the image appear using a formula i can drag down. hope this is clear, thanks you your help!

 

[pbornemeier]

If you use Conditional formatting with the circle Icon Sets then you get the shapes you are seeking.

 

[63falcondude]

Here is a formula that you can place in another cell:

=CHOOSE(G1,"◔","◑","◕","●")

If you want the shape to appear in the same cell that you enter the value in, that will require VBA.