Here's the question: Is it possible to have Excel display a .jpeg or .gif
image based on a conditional value in a cell?

Example: If A1=5 then display abc.jpeg if not, display nothing.

Here's the application: My end users copy and paste from a "green screen"
to Excel. Excel manipulates the data and creates a sheet that can be printed
out and reviewed with our clients. In this case, the "green screen" has an
indicator to designate whether our client is a Five Star Dealer or not.

I know that I can reference a cell to display "Five Star Dealer" but it
would much cooler if I could use the Five Star logo.

Even better, is there a way to change the formatting of a line chart to
conditionally insert the Five Star logo?

Thanks in advance for any help/suggestions that may be offered.


SBH