Conditional Formatting

Imagine you have created a series of awesome Google Forms, or you are getting a bunch of spreadsheets from a recently Galileo assessment...