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.