Looking up and displaying a icon based on a cell value
 

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

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

Ola Sandström


or maybe you wanted: IF(C530,":-(",":-)")


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378659

try
=if(c530,":-(",":-)")

"Marina Limeira" wrote:

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

I want show clipart or icons, not text.

also ideas?


"bj" escreveu na mensagem
...
try
=if(c530,":-(",":-)")

"Marina Limeira" wrote:

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

You will have to have a macro to do that.

"Marina Limeira" wrote:

I want show clipart or icons, not text.

also ideas?


"bj" escreveu na mensagem
...
try
=if(c530,":-(",":-)")

"Marina Limeira" wrote:

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

You have another reply at your first post.

Marina Limeira wrote:

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

--

Dave Peterson

Another alternative is to use the Camera button (active picture link):
http://www.excelforum.com/showthread...ghlight=camera

Or a picture list:
http://www.dicks-blog.com/archives/2...t-of-pictures/

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378659

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


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 18:43:22 -0500, Dave Peterson
wrote:

You have another reply at your first post.

Marina Limeira wrote:

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