Looking up and displaying a icon based on a cell value

[Marina Limeira]

How I Looking up and displaying a icon based on a cell value ?
Example:

icon when cell C5 <=30
icon :-( when cell c5 >30

and where insert the icons ?

thanks

Marina

 

[olasa]

Write this formula: =IF(C5>30,CHAR(74),CHAR(76))
Then change the font to Wingdings

Ola Sandström


or maybe you wanted: IF(C5>30,":-(","")

 

[Guest]

try
=if(c5>30,":-(","")

 

[Marina Limeira]

I want show clipart or icons, not text.

also ideas?

 

[Guest]

You will have to have a macro to do that.

I want show clipart or icons, not text.

also ideas?

 

[Dave Peterson]

You have another reply at your first post.

How I Looking up and displaying a icon based on a cell value ?
Example:

icon when cell C5 <=30
icon :-( when cell c5 >30

and where insert the icons ?

thanks

Marina

 

[olasa]

Another alternative is to use the Camera button (active picture link):
http://www.excelforum.com/showthread.php?t=339328&highlight=camera

Or a picture list:
http://www.dicks-blog.com/archives/2005/05/17/showing-a-picture-from-a-list-of-pictures/

HTH
Ola Sandström

 

[Gord Dibben]

And another reply at your other "Clip Art" post in microsoft.public.excel news
group.


Gord Dibben Excel MVP