thanks for the reply. But what I need is THAT to happen conditionally. e.g. only displays the image in cell when I hover over it. I basically need to exchange the green colour I currently have conditionally formatted (linked with the rollover hyperlink) with an image of my choice- which is an option it simple does not offer when conditionally formatting cells.

I am more than happy to vba it. if you know how to do that of course or could give me an example>