View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] zigzagdna@yahoo.com is offline
external usenet poster
 
Posts: 16
Default 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.