IF Statement to place images/pictures

I am completely stumped and spent over 20 hours trying to figure out this problem. There are a ton of examples on the net on how to do this using code, not using code, etc. I have attached the sample of what I have been able to do so far.

In this example I have used the non code approach. Using Name Lists to assign pictures, I was able to get this to work, the problem is that I would have to create hundreds of name lists to get it to work on all cells, unless I'm missing something.
If you look at Column C - I basically want to assign a picture instead of the word relating to the color in Column A. As you can see in the sample I was able to get this to work, but as I mentioned I would have to literally create hundreds of lists to do it across Column A,D,F,H, etc. I'm sure you get the point. I actually started doing this, if you look at the name lists. Then I thought, there has to be an easier way to do this.

So, here I am asking for help.

Thanks all,

I suggest conditional formatting to do your coloring.

Excel 2003 doesn't support format-by-color-scale, so I've done examples "color when cell contains value" rules on E2:E31.

You can offset the test range if you want like a little "O" as like a traffic sign (maybe the filled-in dot from the wingdings font) and color that too; you can even wrap it with an IF(score=good, "O", "") to error-test for blank or out or range values or something as well. I've demonstrated that in column H (I inserted a new colmn between GM% code and the CMSR column).

Anyway, I feel like conditional formatting with some clever font use will deliver what you want much more easily.

...And you can do it without VBA, too.

This totally works great. Thank you for the help.