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