Conditional Formatting Inserted Object without VBA?

[jcuffel]

Guys,

I did a search on this subject, but didn't find a great answer. Please see the illustration below.

I have inserted the U.S. map in a spreadsheet, and want to change the color of each state based on its recovery %.

I know how to label each state with the amount from each cell, but would really like to color code each object. Is this possible without VBA?

I am running Windows 7 Professional and MS Excel 2013. Any help would be greatly appreciated!


Jason

 

[jcuffel]

BUMP.

Hoping someone in the afternoon crowd will be able to help me with this.

Thanks again.

 

[jcuffel]

BUMP.

I'm just learning VBA's, so I'm open to code that will change the color of each state by its recovery % in the legend.

Thanks.

 

[jcuffel]

Anyone willing to help with this? I've been following this: Conditional Color of Shapes as it is pretty much exactly what I'm wanting to do.

However, I keep getting an "Else without If" error.

Thanks,

Jason