Skip to content
Playback Speed:
Transcript

In the previous video, you set conditional formatting rules so that cells with specific values display different fill colors.

In this video, you will add numbers and colors to your spreadsheet to complete your pixel art project.

To start, open the conditional formatting rules to 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.

Great job!

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.

Next
Instructions
  1. Open the conditional formatting rules to see your color values.
  2. Add values to color cells in your spreadsheet.
  3. Complete your image.
  4. Select a custom range for your background.
  5. Add a new rule to set a background color.