Google Sheets Conditional Formatting

Google Sheets Conditional Formatting

Author: Zachary Waycott
  • I will be able to use conditional formatting to grade multiple test questions at once.
  • I will be able to use conditional formatting to change the font color of cells based on their content.

Conditional formatting is a very useful part of all spreadsheet programs if used properly. We will begin with a common use by teachers which is to grade. After this opening lesson we will use conditional formatting to create more complex items such as color coded lists of point leaders. Giving gold, silver, and bronze backgrounds based on which place a person is in.

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

28 Sophia partners guarantee credit transfer.

263 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 25 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.


Google Spreadsheet Conditional Formatting

This video gives a short run down of the basics of conditional formatting.

Source: Youtube.com

Try it yourself

  1. As we have done in the past I would like you to create a short quiz using Google Forms.
  2. Send this quiz to each student in your class.
  3. When all students have taken your quiz responses in Google Sheets
  4. Use conditional formatting to give correct answers green backgrounds and incorrect answers red backgrounds.