Conditional formatting multiple colors based on multiple data

[seeker123]

Hi everyone,

I have a large table.like below
[TABLE="class: grid, width: 374"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]john[/TD]
[TD]steve[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]mary[/TD]
[TD]john[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]steve[/TD]
[TD]james[/TD]
[/TR]
</tbody>[/TABLE]

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?