Display picture with Conditional Formatting

[Sued]

I need to display one of 3 small pictures in Excel, based
on a figure in a given cell. I can use conditional
formatting to colour the background of another cell based
on this value but cannot see how to display a picture or
alternatively change the colour of a drawing object.

 

[Domenic]

I need to display one of 3 small pictures in Excel, based
on a figure in a given cell.

Have a look at the following...

http://www.mcgimpsey.com/excel/lookuppics.html

 

[Sued]

Thanks very much - followed these instructions and it
worked fine.