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(C5>30,CHAR(74),CHAR(76))
Then change the font to Wingdings

Ola Sandström


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

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

"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" <[email protected]> escreveu na mensagem
news:[email protected]...
> try
> =if(c5>30,":-(",":-)")
>
> "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" <[email protected]> escreveu na mensagem
> news:[email protected]...
> > try
> > =if(c5>30,":-(",":-)")
> >
> > "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
> >>
> >>
> >>
>
>
>

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

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

HTH
Ola Sandström

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

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 <[email protected]>
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