image according to data

  1. A

    Image with IF Condition

    Is it possible that if a specific cell is blank then the desired cell should be blank and if specific cell is not blank then the desired cell should display a picture. I am having such a situation in my result card. I wish if result card shows the "Pass" or "Fail" Status only then the next cell...
  2. J

    Lookup cell in array with image

    I'm trying to create a complete database of professional hockey seasons for all leagues that have existed in North America. The end goal is to be able to state a year/season and which league active in that year I want to display. The first part of completing this is to copy out the standings...
  3. VBA learner ITG

    Excel VBA & Fill certain part of the Image based on cell value

    Hi all, Firstly thank you for taking the time to read my post.. My Question: I have an image that I want to put into into excel document and when a user completes a certain cell value corresponding to the part of the image it fills in the specific part of the image with that cell value. For...
  4. A

    Index Match Pictures Or VBA Match Pictures

    I have a spread sheet with hundreds of part numbers, SKU, and matching photos. I need to be able to show the correct image based on the SKU. It can be index match, vba, vlookup, I'm find with anything. The only things I've been able to find online use a drop down list and this will not work for...
  5. N

    VB Help - Use Image url to insert image and resize (repeat 100 times)

    Hey, Please help a NON coder, I need a VB code that does the following; Sheet 1 Cell C10 - Contains an image url (this can either be a file location or web address) I need to copy that url and use that to insert picture in cell J10 Once the image is in cell J10 the image width needs to be...
  6. I

    How to enter value in cell and image appears based on value?? PLEASE HELP!

    hi everyone, I am trying to find out if there is a way to have an image automatically appear in my cell once i enter a value. For example if it enter the number "1" i want a quarter circle to appear in that same cell, if i enter the number "2" then a half circle appears in that cell and so on. I...
  7. apgmin

    Mail merge

    I know about mailmerge between excel and word. In this I can get the excel data to be inserted in the word file. I make my class trasncript through mailmerge. Is there a way to also mailmerge the photo of the student ( So that the photo of the student gets printed on the transcript ) Also can...
  8. J

    Image according to ID

    Dear Experts Hi, I need your guidance regarding showing related images, 1. In drive D I have a folder name Database 2. One of Subfolder exists here is named Images (contains lots of images named by ID, 11,12,13 etc.) 3. An Excel Workbook exists here in the database folder 4. One of worksheet...
  9. R

    Macros to copy image

    I have written a macro which calls a symbol based on a cell value (For example: if the value is <4 a red circle appears, if it is > 4 a green circle appears). I have 10 different worksheets which has either this red or green symbols. Now I have a cover sheet where I need to populate these...
  10. L

    Insert Image URL Images Into Cells

    I have a dropdown that currently everything on a dashboard is changing against depending on which month is selected. I also have images that I want to show. The images are all hosted online. I have code from another thread...
  11. J

    Custom Image to Conditional Formatting

    I have been asked to add a custom image (a thumbs up) to each cell that has a higher number than the previous one. I already have conditional formatting to shade this cell blue. I can add the standard red, yellow, green lights or arrows, but need help for the custom picture!
  12. J

    VBA / MACRO for inserting picture based on the contents of a cell changes

    Hi Im wondering if anyone can help me with something. Im looking to insert a picture into my excel sheet based on the contents of an input cell. so when name in the input cell changes so does the logo/picture. any help would be much appreciated. Im currently using the Mr.Excel Picture lookup...
  13. C

    Display Image from URL Generated by Cell Value

    Hi All, I'm hoping someone can help. I have list of items, each of which has a barcode value. I want these barcodes to dsiplay in the last column. Unfortunately, add-in's aren't usable as the spreadsheet needs to be used by a number of users. I have previously used google sheets, where...
  14. H

    VBA to insert images from file path

    <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> to insert images from file path Basically I have an Excel...
  15. S

    Add logo to Word based on client number in Access

    Dear all, My Access database is connected to my Word application and upon opening the document a pop-up asks to select a client number to fill the bookmarks. The data contains things like company name, address, e-mail, website. My problem: I'd like to add a client logo to the form 1.) I...
  16. B

    Userform: Set image to visible based on selected listbox item

    Hello all, I have a small UI where I would like to display an image based on what item is selected in a listbox. The listbox is multi-coulumn, and the data I want is from the 2nd Column, so I pull the value from the 2nd column and save it in a variable. The idea is that I have each image...
  17. P

    Insert Web / WWW Image Into Cell

    Setup:OS: WinXP with latest service pack XL: 2010 version IE: v8.0.6 Problem: I have a spreadsheet that I need to insert nations' flags into individual cells. I would like to do this using URLs for each nation in cells adjacent to where the flags will be. The URLs are of certain...
  18. C

    URGENT! Please Help (: Formula to add image according to data input

    First of all, I am fairly new to excel and I am working on a project for a friend and would kindly like your help or input. This is urgent, so I would appreciate any suggestions (: Also, apologies in advance, due to my lack of excel experience, I'm not too familiar with excel lingo. So please be...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top