Conditional Formatting with Images

[Evy]

Hi,

I'm trying to create a set of conditional conditions for a few rows of cells where if the input is a certain text, a specific image will be desplayed.

In summary.
In cell A. will contain a unique item eg, A1 = Apple, A2= Tea cup, A3= computer, etc. There will be a lot of them. In Cell B of each unique item there will be a drop down list which contains the following options "Tall", "Round", "Spike", "Lost", which any one of them can be selected.

In Sheet 2, I have a list that references what was recorded in column A (so replicate what is in column A). What I also want to do is have conditional formating to provide a image of the colour option that was selected, so if they chose 'Round' will have an image of a circle. Lost will have a image of a Diamond and so on. And that will be done for each item in A.

I havent been able to find a solution to achieve the above by auto generating the images that uses a similar technique to Conditional Formatting. Is there any way of archieving what I need?

Thanks

[AndyLitch]

DisplayPics.xlsm

Is this the kind of thing ??

Please Login or Register  to view this content.

SORRY - DISREGARD THAT, I MISREAD THE QUESTION..