function to insert a picture
 

I am looking for a formula to insert pictureA if X0, pictureB if X<0. I
have pasted the pictures at the bottom of my template and have referenced
those cells in the formula, but I dont think it recognizes that there is a
picture in the referenced cell.

function to insert a picture
 

One way

http://www.mcgimpsey.com/excel/lookuppics.html

--

Regards,

Peo Sjoblom

"movermike" wrote in message
...
I am looking for a formula to insert pictureA if X0, pictureB if X<0. I
have pasted the pictures at the bottom of my template and have referenced
those cells in the formula, but I dont think it recognizes that there is a
picture in the referenced cell.

function to insert a picture
 

Tried your macro and got a "Me code error"

"movermike" wrote:

I am looking for a formula to insert pictureA if X0, pictureB if X<0. I
have pasted the pictures at the bottom of my template and have referenced
those cells in the formula, but I dont think it recognizes that there is a
picture in the referenced cell.