What you can do is to put two picture on top of each other and bring the one
you want to the front. I did it yesterday for somebody. I used a
worksheet_change function. Based on a value in a pacrticular cell I moved
one of 3 pictures to the front. I used

ActiveSheet.Shapes("Picture 1").ShapeRange.ZOrder msoBringToFront

"Big D" wrote:

Does Excel allow you to assign a value to a picture and vice versa?

I want to create a database that can create a visual report. The database
would be a table with specific percentages. However, when I need to generate
a report, those percentages need to be translated into pictures.

An example: A worker completes one task and not the other. The database
records a 1 to show the task is completed or 0 to show the task has not been
completed. When I need to print the worker's evaluation report, I want the
printout to show a happy face if the task was completed and an unhappy face
if it wasn't completed.

Suggestions?

Much appreciated!