View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
balayon balayon is offline
external usenet poster
 
Posts: 2
Default Macro to automatically paste a pic based on a certain conditio

Thanks for the reply, Tom. However, I only need one picture for one
criteria. If a cell is 0 or less, then a frown would appear. Is this
possible without having to create a dB?

"Tom Ogilvy" wrote:

http://www.mcgimpsey.com/excel/lookuppics.html

--
Regards,
Tom Ogilvy


"balayon" wrote:

Situation:
When a criteria is met: example: "cell A4 is less than 0", I would like
Excel to automatically paste a certain .jpg in an adjacent cell.

I've tried conditional formatting, however, it would only allow me to format
a cell or range of cells rather than to "add" something such as a picture.

Anyone know of a solution for this?
I currently am running Excel 2002.

Thank you!