Do you often find yourself starring down a sea of numbers on a spreadsheet not really sure what it all means? For more visual folks, conditional formatting might be a great option for you and it is super easy to do. It is a tool that formats the cells in a spreadsheet based on the data in it. You can do more basic "if this is true color it that" type formatting or get more complicated with a color scale based on the distribution of the numbers. It is certainly one of my favorite features of Google Sheets! Check out my quick screencast below to learn how to use this awesome tool.
I had a teacher ask me if there was a way to hide or remove students who are no longer in your class. The answer is maybe. It depends on if they are officially dropped from your class and appearing as red in your roster and gradebook. If not, then no, you cannot remove them until they have been unenrolled from the class. If the student is showing up as red in your gradebook though, you can hide them so you don't have to worry about them. Here is a screenshot to help you do it: