Need Help Inserting a Picture into Excel 1

[JVZ]

I need some help on how to insert a picture into a cell.

The cell (A2) is set up like:

=if(A1=B1, "check ok", "Error&quot

I would like to do is insert a picture into A1, instead of the words "check ok" if A1=B1. Anybody have any ideas on how I can perform this action?

 

[Zathras]

Not sure how you can insert a picture into A1 from a formula in A2, but if you want to display a picture instead of words in A2, you could use the Wingdings font and change the formula to something like this:
[blue]

   =IF(A1=B1,"ü","x")

[/color]
The &quot;ü&quot; character shows as a check mark and can be entered by typing <Alt>0252 The &quot;x&quot; shows as an x inside a box. (If you want the check mark in a box, use <Alt>0254.)

Change the font to Wingdings and set the size to whatever looks best to you.

 

[JVZ]

That works...thanks for your help!