Conditional format shapes
 

I'm looking to use data in a table (ie state names and population data) and
how to use data in the population column to change the color of polygon
shapes I create (ie shape of state traced on a background image of country
map.) Is it possible to use the conditional formatting option to change the
color of a polygon instead of only the cell? It would be great to use Excel
to do some GIS presentations. I've heard it can be done in VBA but I don't
know the code at all.