Scaled Conditional Formatting Arrives in Google Sheets

Good news spreadsheet people: you can now use colour scales in the conditional formatting in Google Sheets.  So now you can get a quick visual representation of a group comparison.  As a teacher I occasionally need to rank student achievement across a whole class / cohort (the more common and important analyses are those against an individual student’s own benchmarks).  So this newly added feature should prove useful for my grade book.

G Sheets Conditional Formatting - scales

Advertisements