I have a situation where I am using data validation for input into a cell (a specified list). What I would like to do is to have the user choose a word from the pull down list (example: "Goal"), and have an icon show up in the cell. I have tried using Conditional Formatting (showing the Icon only), but there is no place the chose Text with a link to the text from the data validation pull down text.

Also, for one of the icons in the set, I would like to use a custom picture, but I don't see that as an option.