Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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. –  reannual Jun 19 at 14:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.