Skip to main content

Transcript

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

To complete this lesson you: created a spreadsheet and gave it a title, searched for an image to guide your artwork, created a grid in your spreadsheet, added conditional formatting rules to assign a color to each number in your spreadsheet, created a piece of art by entering those numbers into your spreadsheet, added a background color, and 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 or create a list of colleges to compare their locations.

You can use practical digital tools for creative projects, too, like making sticky note murals with each sticky note representing a pixel.

Or create other 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.