Conditional format based on criteria
 

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

Conditional format based on criteria
 

Select the entire sheet (A1 active),
then apply CF using Formula Is:
=AND($B15,$C260,$D260)
Format to taste, ok out

The above will format entire rows satisfying the 3 conditions in cols B to D
(Attendance, Math & History)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Syahira" wrote:
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

Conditional format based on criteria
 

Errata:

Line
=AND($B15,$C260,$D260)

should read as:
=AND($B15,$C160,$D160)

Then just select the entire row1 (your col headers),
and delete the CF applied from that row
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---