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.