Conditional Coloring JPG Map

[troilii]

Hi all!

So I have been trying to come up with this code, which would color different countries on my JPG map, on which each country is a separate image, meaning that i will given them each a distinct name. I want the code to pull data from a table and based on that color the country either green, yellow or red. Im also including the workbook with the map.

So far, i have only done this:

Please Login or Register  to view this content.

MAP-Test.xlsm



Any help would be appreciated!


Thanks!

[bulina2k]

What is the color/rating criteria?

[troilii]

Hi bulina!

larger than 0.25 is green
between 0.25 and -0.25 is yellow
smaller than -0.25 is red.

Regards,

troi

[bulina2k]

check this code

Please Login or Register  to view this content.

[troilii]

Okay, please explain me, how does it work, because this thing is just awesome. Ive done the code before for excel charts, but never to an actual jpg object.

Thank you so much!

[bulina2k]

Well, it's just another way to refer the Shape object. Of course looking back I found yet another, more direct way:

Please Login or Register  to view this content.

may be replaced by

Please Login or Register  to view this content.

cel being each country name in the range S5 - S & last used row
and cel.offset(,1) the coresponding value.

If you have other questions please ask, if not please mark the thread SOLVED and Add Reputation if you wish.

[troilii]

Thanks!

Reputation already added a while ago!

[troilii]

Bulina, sent you a PM!