Most valuable professional
  • Hot Topics

Excel Conditional Formatting to make picture visible? VBA needed?

My brain is starting to hurt from reading/experimenting and am not getting any closer. I was hoping one of the forum geniuses might have pity and lend me a hand? I would like to make a graphic (same graphic) placed in about 100 cells appear in those cells only (and be invisible otherwise) when the following is true of the cell: This is the conditional formatting formula: True Applies to: =$D$172:$D$222,$F$172:$F$222,$H$172:$H$222,$J$172:$J$222,$L$172:$L$222 The images (same graphic) are individually named for the cells in which they reside... and are named D172,D173,D175,... F172,F173,F174... etc. The VBA code is completely stumping me (have to do with VBA right?).. any direction would be welcome and VERY much appreciated. Thanks in advance for any help you can provide! Last edited by hinsdale1; Yesterday at 01:27 AM.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of April 4, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel