Hello all!

I'm trying to figure out how to use a picture to illustrate the % of college degree completions in Oregon. I would like to format a picture, say the level of transparency, depending on the % completion in another cell. So, for example, if I crop the picture in quarters, and the completion rate is only 50% in cell A1, I would like the bottom 2 quarters to be in full color, and the top 2 quarters to be 40% transparent.

Is this possible? And if so...can you help me with the code?

Thanks!