How to display an "icon" instead of cell value
 

I hope I can describe this; this must be simple who knows excel icons:

I have an excel cell. e.e., T6 which uses following formula:
=HLOOKUP(BO105,BO102:BP103,2,FALSE)

The BO012:BP103 simplay has following 2 x 2 cells:

1 0
icon for yes (green "check box") icon for no (red x)

In T6, one does not see the icon for yes, instead sees a character ü; how can I show the "icon" instead, what formatting I have to do.

Thnaks a lot.

How to display an "icon" instead of cell value
 

Hi,

Am Sat, 10 Nov 2012 09:37:22 -0800 (PST) schrieb :

I have an excel cell. e.e., T6 which uses following formula:
=HLOOKUP(BO105,BO102:BP103,2,FALSE)

The BO012:BP103 simplay has following 2 x 2 cells:

1 0
icon for yes (green "check box") icon for no (red x)

try in T6:
=IF(HLOOKUP(BO112,BO102:BP103,2,0)=1,"R","V")
and change the font name in T6 to Wingdings2
The color you can add with Conditional Formatting


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2