+ Reply to Thread
Results 1 to 2 of 2

Formula to show a picture?

  1. #1
    Registered User
    Join Date
    11-25-2005
    Posts
    18

    Formula to show a picture?

    Hi there,

    Lets say in Sheet 2 I had pasted 3 pictures

    On sheet 1:

    A1=1
    A2=2

    Is it possible to put a formula in B1 that has this logic:

    If A1=1 then show picture 1, otherwise show picture 3

    so if the value in A1 changed to 2 then Picture 3 should show in cell B1.


    any suggestions on any other methods of inserting pictures into an excel spreadsheet using formulas based on values in a cell would be much appreciated.

    Thanks,

    AJ
    Last edited by Smeeg; 01-12-2007 at 12:35 PM.

  2. #2
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    A picture on a worksheet is a "shape object" ... in many ways no different from an auto shape you might draw on the worksheet. What you want to do is to change the "visible" property of that shape.

    I know of no way to do that with a worksheet function. It is rather easy to do with a macro. Are you willing to use a macro?

    Please Login or Register  to view this content.
    Last edited by MSP77079; 01-12-2007 at 10:02 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1