Looking up and displaying a icon based on a cell value

M

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
 
O

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,":-(",":)")
 
D

Dave Peterson

You have another reply at your first post.

Marina said:
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
Click to expand...
 
G

Gord Dibben

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


Gord Dibben Excel MVP
 
Top