Conditional Formatting to match a list

[Tradegear]

I'm trying to change the cell colour based on if the text is found in another list, but I'm struggling.
Attached is a simplified version of the data I'm working with.
Essentially, I want the names in column B to be either red or yellow depending on which 1A or 2B list they appear in.
Any help would be much appreciated.

 

[Phuoc]

You can use =COUNTIF($D$2:$D$7,B2) for yellow color and =COUNTIF($E$2:$E$7,B2) for red color.

 

[Tradegear]

I've done that, but it doesn't seem to be working correctly.
The D "yellow" column formula seems to be reading the red E column. And then E column formula is just random!