conditional formatting feature

[AMIRD]

Hello.
I have a table with 4 columns A B C D.
The table represents names of students (column A), and three desired friends in class (columns B,C,D).
For each student, I would like to color in blue cells of friends who are with him in class, and in red friends who are not with him in class.

Can anyone tell me what is the correct conditional formatting formula for this?
Thank you so much!

For example for this table:

D	C	B	A
JESSICA	RUTH	DAVID	TOM
RAULI	DAN	STEPHEN	MARK
TOM	MIKE	OFER	RUTH
STEPHEN	RUTH	TOM	JOHN
JOHN	DAVID	RUTH	MIKE

<tbody>
</tbody>

should look like this:

D	C	B	A
JESSICA	RUTH	DAVID	TOM
RAULI	DAN	STEPHEN	MARK
TOM	MIKE	OFER	RUTH
STEPHEN	RUTH	TOM	JOHN
JOHN	DAVID	RUTH	MIKE

<tbody>
</tbody>

I need it to work for both cases, in which cells that appear family name first AND for cells in which the private name appears before family name.

(I would like to color the cell's background and not the text's color, but I just don't manage to show it here at the example).

Thank you very very much!