First post, I'm a beginner in Excel so forgive me.
I work in a sales team in the UK and different managers are responsible for certain post codes, and what I would like is for each postcode to change colour according to the appropriate manager. Now I could easily just colour the individual cells but often the territories change, so I therefor want something I can change.
There is a way to do this without VBA as I have a spreadsheet which has lots of formuals too complex for me to decode.
As a starting point, I have a map of the UK in Excel made up of cells (ie. it's not an image).
I know this is a big ask but I'd really appreciate if someone could help. I could email the file if someone needed it.
Thanks.
I work in a sales team in the UK and different managers are responsible for certain post codes, and what I would like is for each postcode to change colour according to the appropriate manager. Now I could easily just colour the individual cells but often the territories change, so I therefor want something I can change.
There is a way to do this without VBA as I have a spreadsheet which has lots of formuals too complex for me to decode.
As a starting point, I have a map of the UK in Excel made up of cells (ie. it's not an image).
I know this is a big ask but I'd really appreciate if someone could help. I could email the file if someone needed it.
Thanks.
