Hello,
I have a list of names with an ID tag of either 1 or 2 against them and a second list of just names.
I am trying to apply conditional formatting to the second list based on two factors.
1) Does the name exist in the first list. I can do this with =match(Cell, Array, 0) no problem.
2) the colour should then depend on the ID tag of 1 or 2 which is on the same row and adjacent column of the name in the first list. e.g.
List 1
John Smith | 1 |
Sam Tucker | 2 |
Any help appreciated
Tripp
I have a list of names with an ID tag of either 1 or 2 against them and a second list of just names.
I am trying to apply conditional formatting to the second list based on two factors.
1) Does the name exist in the first list. I can do this with =match(Cell, Array, 0) no problem.
2) the colour should then depend on the ID tag of 1 or 2 which is on the same row and adjacent column of the name in the first list. e.g.
List 1
John Smith | 1 |
Sam Tucker | 2 |
Any help appreciated
Tripp