Conditional Formatting in Google Sheets

Instructional Goal

The learner will understand how to use conditional formatting in spreadsheets to color-code a grade book.

Performance Objective

Teachers will apply conditional formatting to a Google Sheet based on grades of students and completed with all errors corrected.

Training

Although this covers how to use it in a grade book, you can extrapolate to other Google Sheets uses. Make a copy of the prefilled template. It will be required for the training.

Sample Gradebook

Follow along with the interactive presentation.

View Fullscreen