In the previous video, you set conditional formatting rules so that cellswith specific values display different fill colors.
In this video, you will add numbers and colors to your spreadsheetto complete your pixel art project.
To start, open the conditional formatting rulesto see the values associated with each color.
Use your rules as a key to remember which number paints each color.
Refer to your sample image whenever you need it.
Start with a blank canvas.
Delete any values that you entered previously.
Now, enter values to add color to your spreadsheet.
Add colors cell-by-cell,or click and drag a cell handle to copy the value to multiple cells.
If you find that you need additional colors, simply add another conditional formatting rule.
Complete your image.
Don’t worry if you make a mistake or need to start over.
Conditional formatting makes changing your spreadsheet art simple.
When you have completed your image, add a background color to make the image stand out.
To do this, add another conditional formatting rule that only applies to a range of cells-in this case, the empty cells around your image.
Select the range of cells.
Add a new rule that changes the color if a cell is empty.
Then select a background color.
Now, it’s your turn.
Open the conditional formatting rules to see your color values,add values to color cells in your spreadsheet,complete your image,select a custom range for your background,and add a new rule to set a background color.