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:
[TABLE="align: right"]
<tbody>[TR]
[TD]D
[/TD]
[TD]C
[/TD]
[TD]B
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]JESSICA
[/TD]
[TD]RUTH
[/TD]
[TD]DAVID
[/TD]
[TD]TOM
[/TD]
[/TR]
[TR]
[TD]RAULI
[/TD]
[TD]DAN
[/TD]
[TD]STEPHEN
[/TD]
[TD]MARK
[/TD]
[/TR]
[TR]
[TD]TOM
[/TD]
[TD]MIKE
[/TD]
[TD]OFER
[/TD]
[TD]RUTH
[/TD]
[/TR]
[TR]
[TD]STEPHEN
[/TD]
[TD]RUTH
[/TD]
[TD]TOM
[/TD]
[TD]JOHN
[/TD]
[/TR]
[TR]
[TD]JOHN
[/TD]
[TD]DAVID
[/TD]
[TD]RUTH
[/TD]
[TD]MIKE
[/TD]
[/TR]
</tbody>[/TABLE]

should look like this:
[TABLE="align: right"]
<tbody>[TR]
[TD]D
[/TD]
[TD]C
[/TD]
[TD]B
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]JESSICA
[/TD]
[TD]RUTH
[/TD]
[TD]DAVID
[/TD]
[TD]TOM
[/TD]
[/TR]
[TR]
[TD]RAULI
[/TD]
[TD]DAN
[/TD]
[TD]STEPHEN
[/TD]
[TD]MARK
[/TD]
[/TR]
[TR]
[TD]TOM
[/TD]
[TD]MIKE
[/TD]
[TD]OFER
[/TD]
[TD]RUTH
[/TD]
[/TR]
[TR]
[TD]STEPHEN
[/TD]
[TD]RUTH
[/TD]
[TD]TOM
[/TD]
[TD]JOHN
[/TD]
[/TR]
[TR]
[TD]JOHN
[/TD]
[TD]DAVID
[/TD]
[TD]RUTH
[/TD]
[TD]MIKE
[/TD]
[/TR]
</tbody>[/TABLE]


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!