Can you conditionally format a cell to display an image? rather than just background color

I have a spread sheet with rollover effects to make certain cells turn green/blue when the mouse is hovering over them. however, Instead of turning green, can I make it show an IMAGE in the cell rather than go a colour?

see attached.

It is possible. Not sure whether it can be done conditionally without the use of VBA however.

Without VBA, just go to the 'Insert' Tab, then click insert picture. You can then fiddle with the format of the picture to ensure it fits the cell. Right click picture, click properties, then 'move & size with cell'.

Hope this helps,

TKCZBW

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>

Give me a little while and I'll try and knock something up. It's a very interesting piece of code you have!

ok thanks ha

Here you go, I'm rather happy with this. Only downside is that the picture will still be 'selected'. There is also a tiny bug that When you so it in your 'blue' grid it mildy interferes with your 'green grid'. Nothing serious though.

I have to leave the office now, but wil be back later. A very intriguing bit of code: thankyou!

Please Login or Register  to view this content.

ok .wow. ha ill try it later.

is this completely separate code to add to a module or to delete any previous and just go with this. cant tell instantly by looking at it

Delete all that you have in 'Module1' and replace with this.

you clearly have a better understanding of vba than me lol. I cant get it to work, because there is obviously code I need to adapt to be specific to me but im too new to this to figure it out without head exploding

Can you tell me which lines it is erroring on, if any?

It isn't showing errors, its just not doing anything, like I haven't put a code in at all. when I click "run"(triangle) 'in view code' it pops up like a macro I need to name instead of running the code to the sheet. if you get my point

because im being stupid. could you possible highlight where in your code I have to edit for my sheet etc.