Naveen,

The image as to be in the worksheet and as to be displayed not as an hyperlink

I was looking for something that can automaticlly show the image without
leaving the worksheet where I'm working.

Do u think u can help me?

"Naveen" escreveu:

Paste the following formula in C1

=HYPERLINK(IF(B1A1,"C:\Image1.jpg",IF(B1<A1,"C:\I mage2.jpg","C:\Image3.jpg")),"Image")


Replace "C:\Image1.jpg" with your image and in the same way image2, image3

*** Please do rate ***






"Pedro Serra" wrote:

I'm trying that my excel cell shows one of 3 images according to a if
condition.

Something like:

If value in B1A1 in cell C1 appears image 1
If value in B1<A1 in cell C1 appears image 2
If value in B1=A1 in cell C1 appears image 3

How can I built this?

Thanks