Conditional formatting few cells when the records meet certain number requirements/range.

HI friends

I have a situation and need your help please.

Lets say i am allowing students to choose 3 subjects.
However, each student is given only up to 3 choices of subjects to choose from a long list of subjects.

Each subject would have its min score requirements based on gender.

Hence, if i were to extract an excell sheet of the list of all the students and their respective subject choices 1, 2, 3,
how then do i get excell to highlight their choices which meets the min. score requirements based on gender?

I have uploaded the excell sheet sample with the necessary data and records attached. Appreciate your help please.
The table on the left with yellow highligted cells is what i would like to achieve.