The Jackal
New Member
- Joined
- May 30, 2018
- Messages
- 13
Hi All,
I hope you can help. I have a spreadsheet which involves grouping postcodes.
So on tab 1 i have a list of locations by postcode in column D, about 100 of them.
On Tab 2 i have split these postcodes into 7 zones which are in Columns A C E G I K M with each column having a different colour. This only looks at the first part of the postcode in tab 1 column D and counts how many are in each. So CM3 = 9, CM11 = 5.
What i want tab 1 to do is look at tab 2 and colour match the entire row (A to J) and highlight it the same zone colour.
So...... If column D has a postcode CM1 1BE it will look at tab 2, work out what zone CM1 is in and then highlight that row RED
Or would it be easier to have an extra column next to the postcode and just ask it to look at tab 2 to determine what zone its in and place "Zone 1" which is the column header into that cell. I could then use conditional formatting to highlight the row by looking at that cell.
I hope that makes sense.
I hope you can help. I have a spreadsheet which involves grouping postcodes.
So on tab 1 i have a list of locations by postcode in column D, about 100 of them.
On Tab 2 i have split these postcodes into 7 zones which are in Columns A C E G I K M with each column having a different colour. This only looks at the first part of the postcode in tab 1 column D and counts how many are in each. So CM3 = 9, CM11 = 5.
What i want tab 1 to do is look at tab 2 and colour match the entire row (A to J) and highlight it the same zone colour.
So...... If column D has a postcode CM1 1BE it will look at tab 2, work out what zone CM1 is in and then highlight that row RED
Or would it be easier to have an extra column next to the postcode and just ask it to look at tab 2 to determine what zone its in and place "Zone 1" which is the column header into that cell. I could then use conditional formatting to highlight the row by looking at that cell.
I hope that makes sense.