Displaying image based on cell value

[gsrai31]

Hi all, I have a simple spreadsheet, (an example attached). In sheet2 I have pasted 2 images, in named range A1 = "apple" and in named range B1 = "orange". In sheet1, where a cell value shows apple, I want the cell to display an image of apple, if a cell value shows orange then I want it to dispay an image of orange. This can be on top of the text value in the cell. Each time there is a change in any of the cell, the image should automatically change, so similar to conditional formatting. Can someone please look at the attached example and help. thanks in advance.