Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For an excel cell, I would like to show Image1 if A1 = 1 and show Image2 if A1 = 2. Is there a way of doing that?

share|improve this question

if you are using excel 2007 or later, it now offers conditional formatting with a pre-canned set of icon images
enter image description here

If none of these suit, there is a vba solution to this at this MrExcel page.

share|improve this answer
For some standard use scenarios, like 'is this form fully filled out?', this is infinitely easier than the maddeningly complex solutions bandied about on the web. In Excel 2010 you will find 'Conditional Formatting' on the 'Home' part of the ribbon. Click it and choose 'Icons' or 'Icon sets' or something to that effect. – brokkr Jun 19 '14 at 14:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .