need code to change shape fill to a picture when another cell = 1

I have set up a rollover hyperlink so that when I hover over the cell it changes colour and creates a good effect. To do this I have another cell on the sheet that turns to 1 when the cell in question is hovered over.

I need a code so that when that cell displays the number 1. the object (which is rectangle 2) changes from white fill. to a picture I have saved on my desktop.

I cant quite figure out the coding and have been messing about with things like..

if cell range e.g a1 = 1 then rectangle 2 .userpicture " path " else .solid etc.

any ideas

something like:

Please Login or Register  to view this content.

Im aware its wrong but it will give you idea what I want to do and allow you to easily edit it.

i can edit above code to make it change upon a click to change to image I want.. BUT I cant get it to happen automatically without a click when a cell displays "1". and then need it to go back to white when that cell doesn't display 1

im not using a code for the rollover. im using formula:


=iferror(hyperlink(rollover($a2, a$3),"","") for example. links with other cells and defined name cells & conditional formatting

so I cant just do that.

can you give me example code? for if a cell displays "1" fill shape with image? if not, go back to white fill

automatically? without click

.......How? lol

little help ..............