Monday, December 17, 2012

Color Code Your Data in Google Sheets

Ever have a need to color code your data in Google Sheets?

Here's an easy trick.

1. In Google Spreadsheet, go to the column you want to analyze.
2. Click on the drop-down menu to pull up the choices shown below and select "Conditional formatting."

3. A new window will pop up.

4. Create your rules.

Back in your spreadsheet, you'll see the data displayed in the colors you want.  

This is especially helpful if you have students fill out Google Forms and want to analyze the information they submit.  I use this trick when I ask students to evaluate each other, and I want to color-code their rating.