How to Highlight in Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to highlight a cell in Google Sheets.

How to Highlight in Google Sheets

Highlighting cells in a spreadsheet can be a great way to draw attention to certain data and make it easier to read. For example, you may want to highlight cells with a certain value or highlight cells that are part of a series.

Google Sheets has a few different ways to highlight cells. We can manually highlight a cell by changing the text or fill color.

We can also use conditional formatting to automatically highlight cells that meet certain criteria.

In this guide, we will go over the different ways you can highlight cells in Google Sheets. We will also explain how to use conditional formatting to highlight cells based on certain criteria.

How to Highlight Cells and Text in Google Sheets

Here’s how to highlight cells and text in Google Sheets.

Step 1

First, select the cell you want to highlight.

Step 2

In the toolbar, select the Fill Color icon and choose your desired color.

Step 3

The selected cell should now be highlighted a different fill color from the rest of the cells.

Step 4

We can also highlight specific values by changing the text color instead.

Step 5

We can apply conditional formatting to automatically highlight certain cells based on their values. To accomplish this, select the range you want to use and click on Format > Conditional formatting.

Step 6

In the Conditional format rules panel, adjust the format rules to your liking. You may also change the formatting style to use for all cells that follow the format rules.

Step 7

Cells that follow the conditional formatting rules should now be highlighted automatically

Summary

This guide should be everything you need to highlight cells and text in a Google Sheets spreadsheets.

You may make a copy of this example spreadsheet to test it out on your own.