Conditional Formatting with Google Sheets

Do you often find yourself starring down a sea of numbers on a spreadsheet not really sure what it all means? For more visual folks, conditional formatting might be a great option for you and it is super easy to do. It is a tool that formats the cells in a spreadsheet based on the data in it. You can do more basic "if this is true color it that" type formatting or get more complicated with a color scale based on the distribution of the numbers. It is certainly one of my favorite features of Google Sheets! Check out my quick screencast below to learn how to use this awesome tool.




Never stop learning. Susie from SimmonsClassroom.com

Comments

Post a Comment

Popular posts from this blog

Empowering Students with Choice Boards

Image
An example of a student choice menu that has students chose one item from each "course". I've been working with a teacher lately who has struggled with her students completing a summative paper in her class. This trimester, we're working together to find a way to increase buy in and hopefully have a higher percentage of students complete the project. While investigating options for her, the first thing that came to mind was using a choice board or learning menu to enable her students to select the method that would work best for them rather than prescribing a multimedia project. There are a wide range of ways that you can put choice boards in to action. Tic-Tac-Toe, Menus, Choice Board... there are lots of different words to use to search for them. But the premise for all of them is the same. Give your students a selection of options to chose from and let them go with it. Beyond hopefully boosting engagement, the teacher gets the added benefit of not have a ga...
Read more

End of Year Tech Coach Wrap Up

Image
Hello, Blog Followers! With the end in sight, we wanted to send out one last update from your favorite (ok, only) instructional tech coaches before we all take off for the summer. If you have any questions about any of our updates, please feel free to reach out to us and we'll do our best to support you. ~Stephen & Susie StephenAndSusie.com Make Future You Happy … Write down important logins and passwords that you may forget if you aren't typing them out all summer (or meet with us for help backing them up) (Google, Synergy, etc). Make sure you have back up codes printed or take a photo with your phone for 2 factor authentication. You can also sign up to receive texted codes on your phone. Save your limited working memory! Send yourself a scheduled email that lists important "where did I put that…" information (remotes, cords, files, manipulatives, etc) Software/Apps/Etc: If you find new tools or resources that you are excited about this summer, share them. We wil...
Read more