Google Products, How-To

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.


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.

Follow along with the interactive presentation.

Leave a Reply

Your email address will not be published. Required fields are marked *