How can I change a picture that is displayed in excel depending on a
confition?? I.e. if a cell value is one I want to display a picture of
an apple next to it - if it is 2 I want to display a picture of an
orange next to it (simplified example obviously!!). I know that I can
do this with a macro - but I want the picture to change automatically
as the cell value changes without having to start a macro.

Any help would be appreciated!! Thanks


--
needsomehelp
------------------------------------------------------------------------
needsomehelp's Profile: http://www.excelforum.com/member.php...o&userid=28761
View this thread: http://www.excelforum.com/showthread...hreadid=484504