View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Sean is offline
external usenet poster
 
Posts: 208
Default 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.