how to choose an image instead of a number of text

Hi,

I'm new on this forum. I think a lot of you guys can help me out. I'm looking for a solution for a first step in a simple reporting sheet. What i need is a 'drop down'-box or another method for choosing an image. And also to change the background in a next time:

for example I need to choose a thumbs up, going ok sign, or a cross. And in a way that if last it was ok, now it's a cross that the background turns orange; and if last it was a cross, and nog a thumbs up, the background changes green.

I'm looking for a easy solution that can be copied to several cells.

Please help and see the file.

Thanks in advance.

Jan-Willem

Hi,
Thanks for replying. It doesn't completely solve my question, because I need to use my own pic's. Do you think it is possible to add my own pic's in a way?

Thanks

Originally Posted by xlbiznes

Hi,

One of the easiest way of achieving this would be to use conditional formatting on one cell and copy paste that onto the other cells.

Check your file with the conditional formatting applied and the values to be entered to get the desired flag show up in the cells.

Hope this helps.