How to change image by function?
 

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

How to change image by function?
 

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).

--
regards,
Tom Ogilvy

"K.Parker" wrote in message
...
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