Excel Office 365, how to default the display picture to Blank in a cascading lists

Copper Contributor

Hi there 

Issue 1: I have been trying to find a solution to an issue that I am encountering in vain.

What I am trying to do is to create cascading drop-down lists to go deeper into the selection. A picture gets displayed each time something is selected. However, the previous pictures remain showing even if there is nothing selected "Please Select ...".

Can you please help me find a way to hide the picture when nothing is selected in the list?

 

Issue 2: I want to make every displayed picture as a hot link, when clicked on, a larger one opens in a file externally. Please help.

 

clipboard_image_0.png

0 Replies