Code Conditional Formatting
Guest blog post by Beth Mossholder
A few years ago I was looking for ideas to create some new lessons on spreadsheet, and where do you go to find spreadsheet ideas? Duh. AliceKeeler.com I ran across this post about creating pixel art and spreadsheets. There was an ah-ha moment when I realized two things: 1. Yet again, the answer is a spreadsheet 2. Conditional formatting is coding!
Conditional formatting uses If/then statements to code the spreadsheet. To introduce If/Then statements, have students try paint by numbers.
I created this inspired by Alice’s post.
Here’s the If/then statement:
IF any cell in this sheet has a value of 9 THEN turn the cell black.
Tip: “Add another rule” reduces steps
Usually, once students understand the concept they get pretty creative. This is a great jumping off point to create other sheets, and have deeper conversations with learners about coding concepts and their application in the real world. I started this with 2nd graders and use the concept for teaching students of all ages (including adults) about coding and spreadsheets.
If you would like use this example its linked here.