Yes the first one is possible. Just use conditional formatting to equate the cell to a color for each student. Click Format, then conditional format and put in the appropriate conditions.
For your second issue, I think you would need a VBA Macro to do that.
Keep Up with TechRepublic