Kick off the new school year with lessons from our Back to School 2021 collection to help students express themselves, build relationships, and stay organized.

6. Make Art with Google Sheets Wrap-Up

Playback Speed:

In this lesson, you set conditional formatting rules to assign color to values and create a work of spreadsheet art.

You created a spreadsheet and gave it a title.

You searched for an image to guide your artwork, and you created a grid in your spreadsheet.

You also added conditional formatting rules to assign a color to each number in your spreadsheet.

Then, you created a piece of art by entering those numbers into your spreadsheet, and you added a background color by assigning a rule that filled empty cells with a color.

Finally, you hid the numbers in your image and removed the gridlines from your spreadsheet.

During this project, you learned how to work in a spreadsheet and set conditional formatting rules.

Conditional formatting is practical for organizing all kinds of data For example, you can set conditional formatting rules in a to-do list for school.

You could highlight every completed item in green and every incomplete item in red.

You could also use conditional formatting to highlight items in a shopping list to point out all the items that cost less than ten dollars or more than twenty-five dollars.

Business owners often use conditional formatting to see if invoices have been paid by their clients or not.

But you can use practical digital tools for creative projects, too, like making sticky note murals or craft projects.

Whether it’s pixel art or a spreadsheet for school or work, use conditional formatting in Google Sheets to make your data more colorful and easier to use.

Certificate of Completion

certificate thumbnail

Certificate of Completion

certificate thumbnail