Skip to content

6. Match Text and Fill Colors and Remove Gridlines

Playback Speed:
Transcript

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.

The numbers should still be 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.

To begin, select the entire image.

Then, open conditional formatting.

Select your first rule and match the textcolor 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 your rules.

You do not have to match colors for your background since it contains no text.

Finally, remove the gridlines so pixels of the same color blend together.

Now, it’s your turn. Select all cells and open conditional formatting, Revise the conditional formatting rules to match text colors to fill colors, And remove the gridlines from your spreadsheet.

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.