If cell is not empty insert image

[bobbehman]

Hi everyone!

This sounds simple in principle but I'm failing!
I want to insert an image into a cell (the same image each time) if there is a value showing, I've seen a lot of example of a changing image based on result but not a lot of just inserting an image when a value shows in a cell.
In basic something like:

=IF(ISBLANK(B1),"",image)

It's always the same picture I've tried naming it image, and would want it repeated for all lines in the same column, i.e. a1,b1,c1 etc

Thanks if you have any ideas!

 

[earthworm]

Hi everyone!

This sounds simple in principle but I'm failing!
I want to insert an image into a cell (the same image each time) if there is a value showing, I've seen a lot of example of a changing image based on result but not a lot of just inserting an image when a value shows in a cell.
In basic something like:

=IF(ISBLANK(B1),"",image)

It's always the same picture I've tried naming it image, and would want it repeated for all lines in the same column, i.e. a1,b1,c1 etc

Thanks if you have any ideas!

I don't think you can achieve this through formula . However in VBA you can

 

[bobbehman]

I don't think you can achieve this through formula . However in VBA you can

I Don't suppose anyone would have any idea how to implement this? I assume it will have to be a sheet edit code job but I'm not sure the best place to look for examples!
Thanks