How Conditional Formatting Can Be Used
Conditional formatting can be used for several purposes in a classroom, but the one great thing about using conditional formatting in Google sheets is that you can use it to let the learners know if their answer is correct or wrong instantaneously. For example, if you are teaching a math class, you could set-up the Google sheet to let students know where they are making mistakes in their work (see Figure 1).
Additionally, if you create guided notes for a reading or video, you can let students know if their answers are right or wrong right away (see Figure 2). Overall, conditional formatting in Google sheets has several uses to help learners when they are working through the material in a class.
How to Set-Up Conditional Formatting
To incorporate conditional formatting in a Google sheet, you will want to do the following (see Figure 3):
Watch the “How to Use Conditional Formatting in Google Sheets” video to see how to complete this process and to see the choices you have.
Additional Tips and Tricks
Based on the choices you make, the learners will see whether they are on the right track, or whether they need to make changes to their work. Additionally, when the learner has questions, the Google sheet can be submitted to the instructor, and the instructor can leave comments to guide the learner on specific areas that the learner needs help with (See Figures 6 and 7).
Once you have mastered conditional formatting, there are a few tricks that can help with the formatting of the Google sheet. Watch the “How to Modify Google Sheets” video to learn how to format your Google sheet, so it looks professional.