Forum Discussion
Solved
Insert a conditional image into a cell
Hello everyone,
I have two questions and I'm struggling to find the answer. How can I insert an image into an Excel 365 cell without using macros? Additionally, I want the image in cell B5 to change based on the value in cell A5, all without using macros.
Thank you very much for your help that will save my life.
Here is an example that works with images stored in the workbook itself.
8 Replies
Recent versions of Microsoft 365 have a new function IMAGE
How will the image in cell B5 depend on the value in A5?
- How will the image in cell B5 depend on the value in A5 : I want that the displayed image on the cell B5 changes depending on the value in the cell A5, it's like VLOOKUP but with images
Here is an example (requires Microsoft 365)
- Thank you very much but IMAGE works only with WEB URL and not with images in local storage 😞
Here is an example that works with images stored in the workbook itself.
