Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional formatting autoshapes
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, but can work with it. Many thanks for all help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |