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
[TABLE="width: 404"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]CODE[/TD]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[/TR]
[TR]
[TD]SUBJECT[/TD]
[TD]SUBJECT 010[/TD]
[TD]SUBJECT 010[/TD]
[TD]SUBJECT 009[/TD]
[/TR]
[TR]
[TD]EXAM 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 2[/TD]
[TD]GRADE4[/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]SUBJECT 001[/TD]
[TD]GRADE3[/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]SUBJECT 002[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 003[/TD]
[TD]GRADE1[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 004[/TD]
[TD]GRADE2[/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 005[/TD]
[TD] [/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 006[/TD]
[TD] [/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 007[/TD]
[TD]GRADE3[/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 008[/TD]
[TD]GRADE1[/TD]
[TD]GRADE3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 009[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 010[/TD]
[TD] [/TD]
[TD]GRADE3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 011[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 012[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 013[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 014[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 015[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 404"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]CODE[/TD]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[/TR]
[TR]
[TD]SUBJECT[/TD]
[TD]SUBJECT 010[/TD]
[TD]SUBJECT 010[/TD]
[TD]SUBJECT 009[/TD]
[/TR]
[TR]
[TD]EXAM 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 2[/TD]
[TD]GRADE4[/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]EXAM 1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]SUBJECT 001[/TD]
[TD]GRADE3[/TD]
[TD] [/TD]
[TD]GRADE1[/TD]
[/TR]
[TR]
[TD]SUBJECT 002[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 003[/TD]
[TD]GRADE1[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 004[/TD]
[TD]GRADE2[/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 005[/TD]
[TD] [/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 006[/TD]
[TD] [/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 007[/TD]
[TD]GRADE3[/TD]
[TD]GRADE3[/TD]
[TD]GRADE2[/TD]
[/TR]
[TR]
[TD]SUBJECT 008[/TD]
[TD]GRADE1[/TD]
[TD]GRADE3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 009[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 010[/TD]
[TD] [/TD]
[TD]GRADE3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 011[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 012[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 013[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 014[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SUBJECT 015[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]