clip art

How I show a picture or icon when the value > 50
other when <= 50 ?

also Ideas?

Marina

Marina

Have a look at JE McGimpsey's site for code to show pictures.

Not exactly what you want but maybe get an idea or two.

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


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 13:32:04 -0300, "Marina Limeira"
<[email protected]> wrote:

>How I show a picture or icon when the value > 50
>other when <= 50 ?
>
>also Ideas?
>
>Marina
>

You might want to try this (no vba involved):

I'll assume you want to store the pictures on Sheet2 and show them on
Sheet1.

1)Set the fill color for every cell on Sheet2 to White, then:

For each picture to be displayed (you'll need 3->picOver50, pic50OrLess,
picNoData):
1a. Insert>Picture from file. (select your picture and put it in the sheet).
1b. Select the range of cells that contains the picture and give it a
meaningfull name:
Example:
Insert>Name>Define
Name: picOver50

2)Put a value in your test cell (I'll assume A1).

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo:
=IF(ISNUMBER(Sheet1!$A$1),IF(Sheet1!$A$1>50,INDIRECT("picOver50"),INDIRECT("pic50OrLess")),INDIRECT("picNoData"))
....or whatever cell you chose.

4)Copy/Paste any one of the pictures from Sheet2 into the cell on Sheet1
where you want pictures to display.

5)While the picture is still selected, type this in the formula bar, then
press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the the value of
cell A1.

Each time you change the value of A1, the associated picture will appear in
the picture box and resize appropriately.

Is that something you can work with?

Ron