Colouring autoshapes mapped to cells in excel
 

I have a cluster of autoshapes (map of a city divided into regions)
that I need to colour according to how much that region spent on
services. I have a column with the region names, a column with how
much spending was predicted and a column with the real spend. I have
named each autoshape after the region, but am stuck now. I need the
autoshapes to show up as green if they spent within their budget or red
if not. Am pretty new to VBA. Many thanks for all help.

Colouring autoshapes mapped to cells in excel
 

A good start would be to turn on the macro recorder, select the shape, and
format it. Then turn off the macro recorder.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I have a cluster of autoshapes (map of a city divided into regions)
that I need to colour according to how much that region spent on
services. I have a column with the region names, a column with how
much spending was predicted and a column with the real spend. I have
named each autoshape after the region, but am stuck now. I need the
autoshapes to show up as green if they spent within their budget or red
if not. Am pretty new to VBA. Many thanks for all help.