Conditional formatting multiple colors based on multiple data

[seeker123]

Hi everyone,

I have a large table.like below

	1	2
A1	john	steve
A2	mary	john
A2	steve	james

<colgroup><col><col><col></colgroup><tbody>
</tbody>

and I have a list like this
https://pasteboard.co/HttAw2F.png

Now I want every cell in my first table to be colored based on the second list.how can I do that?



Thanks a lot in advance.

 

[OGCV1]

Are the list and the table in the same sheet?