How to display an "icon" instead of cell value

  • Thread starter Thread starter zigzagdna
  • Start date Start date
Z

zigzagdna

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.
 
Hi,

Am Sat, 10 Nov 2012 09:37:22 -0800 (PST) schrieb (e-mail address removed):
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
 
Back
Top