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.

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.