Use Sophia to knock out your gen-ed requirements quickly and affordably.
Learn more
Sign In
Help
Become a Member
Try for Free
Sign In
Password
Sign In
Forgot your Password?
Create an Account
Let's chat
Or
Close Popup
First, please create an account
Already have a Sophia account?
Sign in
Email Address
Password
Confirm Password
By providing your information, you consent to receive occasional special promotional offers and education opportunities by phone, text message, and email via automated technology from Sophia Learning or one of its affiliates. Consent is not required to purchase goods or services. You can always call us at 1-800-341-0327. See our
privacy policy.
See our most recent
privacy notice.
Create Account
×
Google Sheets Conditional Formatting
Author:
Zachary Waycott
Google Spreadsheet Conditional Formatting
This video gives a short run down of the basics of conditional formatting.
Source: Youtube.com
Try it yourself
As we have done in the past I would like you to create a short quiz using Google Forms.
Send this quiz to each student in your class.
When all students have taken your quiz responses in Google Sheets
Use conditional formatting to give correct answers green backgrounds and incorrect answers red backgrounds.
