Conditional formation/ Highlight a row based on specific columns

[wngadea]

Rules
*Students marked absent under the "All day" column must show supporting period absences. Conversely, students with absences in all period columns (Per0, Per1, Per2, etc.) should have an "All day" absence recorded
*Every "All day" absence must be verified
*As long as a student has been marked present at least one period, school can consider him/her present (All day column should have no absences)

Attendance Code Key

A- Unverified Absence
U- Unexcused Absence (Verified)
E- Excused Absence (Verified)
P- Present
Blank cell - Not absent (counts as Present)
C- Meeting with Connector/Counselor (counts as Present)

[TABLE="width: 371"]
<tbody>[TR]
[TD="class: xl65, width: 318, colspan: 6"]Attendance Error Summary[/TD]
[TD="width: 53"][/TD]
[/TR]
[TR]
[TD="class: xl67, width: 53"][/TD]
[TD="class: xl66, width: 265, colspan: 5"]Yellow # of all day records incorrectly reported as present (all periods are absent)[/TD]
[TD="class: xl63, width: 53"][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 53"][/TD]
[TD="class: xl71, width: 265, colspan: 5"]Green # of all day records incorrectly reported as absent (at least one period present)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77, width: 53"][/TD]
[TD="class: xl66, width: 265, colspan: 5"]Red # of unverified absences[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"][/TD]
[TD="class: xl66, width: 265, colspan: 5"]Total # of Errors[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I had created a conditional format
=$i2=A to show the unverified absences (Red)
absolute value of column I activated since column 2 had to equal to A format in red.

[TABLE="width: 601"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]School[/TD]
[TD]Student#[/TD]
[TD]Day#[/TD]
[TD]Grade[/TD]
[TD]Track[/TD]
[TD]Teacher#[/TD]
[TD]All day[/TD]
[TD]Per0[/TD]
[TD]Per1[/TD]
[TD]Per2[/TD]
[TD]Per3[/TD]
[TD]Per4[/TD]
[TD]Per5[/TD]
[TD]Per6[/TD]
[TD]Per7[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]T[/TD]
[TD][/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD="align: right"]4/24/12[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]135[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]Red 0[/TD]
[TD](A)[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]4/24/12[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]211[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T[/TD]
[TD][/TD]
[TD="align: right"]4/24/12[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4/24/12[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]754[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"] Yellow0[/TD]
[TD](P)[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]4/24/12[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]758[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T[/TD]
[TD][/TD]
[TD="align: right"]4/24/12[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]739[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T[/TD]
[TD="align: right"]4/25/12[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]743[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]Green 0[/TD]
[TD](A)[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]4/25/12[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4/25/12[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]751[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4/25/12[/TD]
[/TR]
</tbody>[/TABLE]