Conditional format based on criteria

[Guest]

I have a file where I want to use conditional format to tell whether this
student qualified for awards or not. Here is the example:

A B C
D

Student Attendance score Math test score History test
score Status

Sam 8 70
50 Qualified

Robsom 9 80
70

Melinda 5 65
70

The condition is:

5 for attendance score
60 for both Math & History test

What I want to know is how to use conditional format to highlight the
students based on the 3 conditions. Thank you

 

[Guest]

Select the entire sheet (A1 active),
then apply CF using Formula Is:
=AND($B1>5,$C2>60,$D2>60)
Format to taste, ok out

The above will format entire rows satisfying the 3 conditions in cols B to D
(Attendance, Math & History)

---

 

[Guest]

Errata:

Line

=AND($B1>5,$C2>60,$D2>60)

should read as:
=AND($B1>5,$C1>60,$D1>60)

Then just select the entire row1 (your col headers),
and delete the CF applied from that row

---