Hi there,
Lets say in Sheet 2 I had pasted 3 pictures
On sheet 1:
A1=1
A2=2
Is it possible to put a formula in B1 that has this logic:
If A1=1 then show picture 1, otherwise show picture 3
so if the value in A1 changed to 2 then Picture 3 should show in cell B1.
any suggestions on any other methods of inserting pictures into an excel spreadsheet using formulas based on values in a cell would be much appreciated.
Thanks,
AJ
Bookmarks