Return a picture using IF formulas

I want to create a formula that will return either a filled-in red circle
with an "R", or a filled in green circle with a "G" to indicate a good/bad
result. I can not find a character within available fonts that has a
filled-circle with alpha characters. If this was available I could use
conditional formatting to change the color. My other attempt was to try and
return a Picture created in powerpoint - red and green circles with alpha
characters, but am not successful.

Thanks for any help!

You could try to use a dynamic Picture link.
Is a bit complicated to explain in detail, so I'll try with an example.

1. Insert a red Circle (autoshape) and add a text R and place it over cell D1.
2. Then add the Icon-button 'Camera'. It located under the Tools menu category.
3. Mark the cell where your button is located (D1)
4. Now Click the camera and paste where your R should be (this is now a active picture link).
5. Next create a Green button and place it over E1.
6. Click on your picture link. The formula bar will show the cell reference =$D$1.
7. Insert a Define Name called Button. and use the formula =IF(A1=1,D1,E1). This will focus the picture link on either the Red or the Green button.

This is the principle.

Ola Sandstrom

To make a short story longer:
http://www.excelforum.com/showthread...d=1#post864663

Ola Sandstrom