How to change image by function?

K

K.Parker

Dear all,

I found that the paste picture link feature is useful. Can I create a link picture that can be
change by function?
Like =IF(A1="USA","show a cell's link","nothing")
If the cell A1 is USA, the picture link will show the content of B1 to C1, if not, show nothing?

Thanks for your help.

K.Parker
 
T

Tom Ogilvy

I think you would have to make B1 to C1 not show anything. The picture link
reflects the linked worksheet. As far as I know you can't edit the linking
formulas if formulas are used (which i doubt).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Place picture in Excel cell 0
VBA Coding Help for Beginner 0
Word macro that can call cells out of Excel for a find and replace 0
VBA for Dependents shortcut menu 0
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Custom Images not showing in Ribbon toggle button 2
Time Calculations Help 5

Top