Hi Peeps
I'm trying to figure out how to create a drop down list for traffic lights that replaced Green, Amber and Red with icons.

For example.
drop down in A1 is "Green, Amber, Red"

When Green is selected, instead of A1 displaying "Green" it changes to display the ICON.JPG. Amber creates the next icon in the sequence of the Conditional Formatting icon set, as does Red.

Any help would be greatly appreciated.