Not sure where you've been with this issue but, could you do something
like:

Sub mytest()

With ActiveCell
if .value = 100 then
.value = J
.Font.Name = "wingdings"
.Font.Size = 22
End With
End Sub

This converts a 100 to a happy face in the active cell.


wrote:
I just got off the phone with the advanced help for Microsoft Excel.
They have explained to me that there is no way of having a picture
(vlookup) appear instead of a number in a cell. I am a teacher and I
am attempting to display a picture instead of a letter for a grade when
a certain percentage is achieved. In other words, an A+ or 100% will
equal a smiley face or something. Somebody help me please.