Skip to main content

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

Most Popular Blog Posts

Hide Dropped Students in Infinite Campus

I had a teacher ask me if there was a way to hide or remove students who are no longer in your class. The answer is maybe. It depends on if they are officially dropped from your class and appearing as red in your roster and gradebook. If not, then no, you cannot remove them until they have been unenrolled from the class. If the student is showing up as red in your gradebook though, you can hide them so you don't have to worry about them. Here is a screenshot to help you do it:

Keynote Interactivity (and my 200th post)

When I talked with teachers about Nearpod last week, there was a teacher at the highschool who really wants to keep his animations within Keynote while having the interactivity like Nearpod . I told him that I'd look into it to see what was possible. Short story: I'm not having any luck at all.

Build with Chrome (Lego Building Time!)

If you are like me, you spent countless hours when you were young building with legos . If you were a parent of kids like me, you spent countless hours vacuuming up those little pieces or hunting for them with your bare feet in the middle of the night (ouch!). When I heard about Build with Chrome yesterday, you can understand why my eyes lit up. What is Build with Chrome? It's this: