Skip to content

5. Match Text and Fill Colors and Remove Gridlines

Playback Speed:
Transcript

In the previous video, you created your image by setting conditional formatting rules and entering numeric values in your project.

You also added a background to your image by applying a rule to a custom range.

In this video, you will revise your original conditional formatting rules, so the numbers are invisible in your image.

You’ll also remove the gridlines from your spreadsheet image.

Currently, the numeric values are still visible in the cells of your project.

To hide these values in order to make your image look cleaner, change the conditional formatting rules and color settings.

Select the entire image.

Then, open conditional formatting.

Select your first rule and match the text color with the fill color.

Be sure to match them exactly.

Matching the text and fill colors hides the numbers in your image.

The values are still there, but all you see is your pixel art!

Now, match the text and fill colors for the rest of the rules.

Then, remove the gridlines.

This enables you to see your image even more clearly.

Finally, rename your file to reflect the subject of your masterpiece.

Now, it’s your turn.

Select all cells and open conditional formatting, revise the conditional formatting rules to match text colors to fill colors, remove the gridlines from your spreadsheet, and rename your spreadsheet.

Next
Instructions
  1. Select all cells and open conditional formatting.
  2. Revise the conditional formatting rules to match text colors to fill colors.
  3. Remove the gridlines from your spreadsheet.
  4. Rename your spreadsheet.