Hi,
How to apply the conditional formatting for blanks cells with multiple criteria of the following data.
https://www.dropbox.com/s/bfumzp5zzwu77bo/CFCB.PNG?dl=0
<colgroup><col span="4"></colgroup><tbody>
</tbody>
How to apply the conditional formatting for blanks cells with multiple criteria of the following data.
https://www.dropbox.com/s/bfumzp5zzwu77bo/CFCB.PNG?dl=0
CODE | A1 | A2 | A3 |
SUBJECT | SUBJECT 010 | SUBJECT 010 | SUBJECT 009 |
EXAM 5 | GRADE1 | ||
EXAM 4 | GRADE1 | ||
EXAM 3 | GRADE1 | ||
EXAM 2 | GRADE4 | GRADE1 | |
EXAM 1 | GRADE1 | ||
SUBJECT 001 | GRADE3 | GRADE1 | |
SUBJECT 002 | |||
SUBJECT 003 | GRADE1 | ||
SUBJECT 004 | GRADE2 | GRADE3 | GRADE2 |
SUBJECT 005 | GRADE3 | GRADE2 | |
SUBJECT 006 | GRADE3 | GRADE2 | |
SUBJECT 007 | GRADE3 | GRADE3 | GRADE2 |
SUBJECT 008 | GRADE1 | GRADE3 | |
SUBJECT 009 | |||
SUBJECT 010 | GRADE3 | ||
SUBJECT 011 | |||
SUBJECT 012 | |||
SUBJECT 013 | |||
SUBJECT 014 | |||
SUBJECT 015 |
<colgroup><col span="4"></colgroup><tbody>
</tbody>