Forum Discussion
Display images in Excel
Hello,
yes, that's possible, if you use a named range and an image shape. I attached a sample file to this post. The sample file includes two sheets. The second one has an image centered in one cell (!) and another cell with the same size, which is empty. Then, I created a named range Image with the formula: =INDEX(Images!$C$3:$C$4;Display!$D$3;1). D3 from the sheet Display contains the simple formula =IF(C3;1;2) and C3 your value TRUE/FALSE. You can adapt this to your needs, of course. Then I added an image Insert/Pictures (pick anyone). When the image is inserted, click on it and in the formula bar, type =Image + Enter. That's it.
Best regards,
Mourad
Hello,
yes, that's possible, if you use a named range and an image shape. I attached a sample file to this post. The sample file includes two sheets. The second one has an image centered in one cell (!) and another cell with the same size, which is empty. Then, I created a named range Image with the formula: =INDEX(Images!$C$3:$C$4;Display!$D$3;1). D3 from the sheet Display contains the simple formula =IF(C3;1;2) and C3 your value TRUE/FALSE. You can adapt this to your needs, of course. Then I added an image Insert/Pictures (pick anyone). When the image is inserted, click on it and in the formula bar, type =Image + Enter. That's it.
Best regards,
Mourad
Wow, this is quite new for me. I got to take time to learn of how it works.
Thank you so much for your help.