Complicated one which is why I am struggling and cant seem to get other suggesstions on this topic to work.
Situation
I have a map of the UK split into 36 zones displayed by 36 freeform shapes on my worksheet. I have a list of 14 teams in a table next to the image to which the zones will be allocated.
Requirements
If possible, I require a map that when zones are allocated to the teams the freeform shape displaying that area would change to the team colour to provide a pictoral representation of assignments.
ie if zone 1, represented by the number 1, is assigned to and entered in the row of team 1 (range O4:S4) the freeform shape covering zone 1 (identified by using the cell reference box which displays "Freeform 80") would change to the colour assigned to team 1.
A team could be assigned up to a maximum of 5 zones so a team's row/ range would run 5 cells.
Also, would like the transparency to be set at 70% so that the map of the uk would still be visible under the freeform shapes.
Would I have to write 36 rules for 14 teams or 14 rules for 36 zones?
Hope that all makes sense. Any help would be appreciated.
Situation
I have a map of the UK split into 36 zones displayed by 36 freeform shapes on my worksheet. I have a list of 14 teams in a table next to the image to which the zones will be allocated.
Requirements
If possible, I require a map that when zones are allocated to the teams the freeform shape displaying that area would change to the team colour to provide a pictoral representation of assignments.
ie if zone 1, represented by the number 1, is assigned to and entered in the row of team 1 (range O4:S4) the freeform shape covering zone 1 (identified by using the cell reference box which displays "Freeform 80") would change to the colour assigned to team 1.
A team could be assigned up to a maximum of 5 zones so a team's row/ range would run 5 cells.
Also, would like the transparency to be set at 70% so that the map of the uk would still be visible under the freeform shapes.
Would I have to write 36 rules for 14 teams or 14 rules for 36 zones?
Hope that all makes sense. Any help would be appreciated.
