Conditional Formatting


Posted by Graham on October 11, 2001 10:58 PM


Is there any way to format a number as an image? I am hoping to use a bitmap to represent an entered number for greater visual impact.

Posted by Dan on October 12, 2001 6:12 AM

Probably anything is possible depending if you want to code VB. Since picture objects are not values, you do not assign a picture to a cell. You place picture objects *over* cells. Since I'm fairly new to VB, I haven't experimented with manipulating picture objects and I wouldn't be able to provide you any code, perhaps someone else can? Is there any way to format a number as an image? I am hoping to use a bitmap to represent an entered number for greater visual impact.



Posted by lenze on October 12, 2001 6:32 AM

http://support.microsoft.com/support/kb/articles/Q213/7/32.ASP?LN=EN-US&SD=gn&FR=0&qry=Image%20Control&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=XLW2K

The above article might get you started