microsoft excel - Turn third cell red if preceding 2 cells =

I am hoping to put together an attendance sheet which highlights a third or fourth cell in a row (12 cells for a 12 week semester) where the preceding 2 cells have values less than 2.

Basically what I want to achieve is a kind of 'red flag' or alert for a student who has been absent for any three consecutive days throughout the entire semester.

Alternatively, a cell in an end column with a note such as "refer to academic support" when these criteria are met could be a good alternative.

Can anyone help?

Thank you.