Sir - I have an excel sheet with countries and several indicators. I also have a world map made of smaller shapes. I can manually color each country as i please. What i however want is that the countries get colored as the indicator change.
For example. If GDP growth rate (cell B9) for USA (Cell A9) is above 0.02, the shape called USA is colored green, between 0.02 and 0 Yellow, and below 0 red. Is that possible?
Additionally, as you probably have understood, i have close to 200 shapes and equal number of cells
. Are there any way to do this semi automatic?
Thank you a million!!
For example. If GDP growth rate (cell B9) for USA (Cell A9) is above 0.02, the shape called USA is colored green, between 0.02 and 0 Yellow, and below 0 red. Is that possible?
Additionally, as you probably have understood, i have close to 200 shapes and equal number of cells
. Are there any way to do this semi automatic?Thank you a million!!