+ Reply to Thread
Results 1 to 3 of 3

Help with displaying a picture based on a formula

  1. #1
    Registered User
    Join Date
    02-23-2010
    Location
    Sarnia, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    8

    Help with displaying a picture based on a formula

    I am working on a spreadsheet that calculates sales results weekly / monthly / quarterly / and year to date. I need to be able to get a picture to automatically populate in a specific fields based on the sales results for that week / month / quarter / year. There are 3 pictures indicating: sales below budget (sad face), above budget but below goal (black dot), and above goal (gold star). I have tried using non-macro means, but I can't seem to get anything to work for use with multiple cells and I do not wish to use conventional conditional formatting. I do not know nearly enough about macros or VBA to even attempt this type of thing. Any help would be greatly appreciated.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Help with displaying a picture based on a formula

    Here is tutorial
    http://www.excelguru.ca/content.php?...P-for-Pictures
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    02-23-2010
    Location
    Sarnia, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Help with displaying a picture based on a formula

    still working on getting this tutorial to work for me. The provided link has been useful. Just trying to customize it to my needs. It is proving to be very difficult. Thank you very much for your reply.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Looking up and displaying a picture based on a cell value
    By CloseShaveDave in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2013, 06:53 AM
  2. Displaying Picture based on cell value
    By fjowls in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2013, 12:15 PM
  3. insert a picture based on a formula
    By Analyst in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-29-2012, 02:41 AM
  4. displaying a picture on a Form
    By z0rpia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2009, 08:39 PM
  5. object displaying picture
    By ganero in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2008, 08:27 PM

Tags for this Thread

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