Hi all,
Bit of a toughy here, and not really sure how to go about it.
I have a spreadsheet of data on Sheet1, which is a table of data. Column M contains a URN and there will be a matching number to this, that links to a location in Sheet2.
If the number in Column M AND AE on Sheet1 (o2, 3, EE, Vodafone) matches the numbers AND the network in the table on Sheet 2, then cells M:T should be coloured by the colour of the location in Column B on the table in Sheet2.
The table in Sheet 2 is dynamic and will change, so could be A:J from A1 down to J100.
There will be number matches between Sheet1 and Sheet2, but where there is no network match - these are to stay uncoloured, it is only where both match.
The same then needs to be applied to column U, where the number needs to match the numbers in Sheet 2 and again AE needs to match the network in Sheet2.
Sheet1 in the attached file shows where numbers and the network in Sheet2 match they are coloured up.
Not sure how to go about it.
Bookmarks