Hi there,
First, thanks in advance for any help.
I am working on an MS Excel 2010 spreadsheet that tracks attendance records. If students miss two or more days in a row, I need to follow up on it. My goal is to create a status column for each student where the cell will turn red if they miss two or more days in a row so it brings it to my attention.
If students are in class, under that day's column it says "attended." If they did not attend, the cell is blank. So if there are two consecutive empty cells in a student's row I want their status to turn red. For example if student 1 has empty cells in cells b1 and c1, I want their "status" cell to be red.
I have tried doing this using nested IF functions and using ISBLANK but I frankly don't think I am anywhere close to figuring it out.
First, thanks in advance for any help.
I am working on an MS Excel 2010 spreadsheet that tracks attendance records. If students miss two or more days in a row, I need to follow up on it. My goal is to create a status column for each student where the cell will turn red if they miss two or more days in a row so it brings it to my attention.
If students are in class, under that day's column it says "attended." If they did not attend, the cell is blank. So if there are two consecutive empty cells in a student's row I want their status to turn red. For example if student 1 has empty cells in cells b1 and c1, I want their "status" cell to be red.
I have tried doing this using nested IF functions and using ISBLANK but I frankly don't think I am anywhere close to figuring it out.