How To Highlight Cells In Google Sheets In 2022 (+ Examples)

Last Updated on November 2, 2023 by Jake Sheridan

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

How To Highlight Cells In Google Sheets

• How To Highlight Cells In Google Sheets
• Summary

When working in Google Sheets, sometimes you want to call attention to certain cells.

Fortunately, Google Sheets makes this easy to do by highlighting those cells to call attention to them. Follow these instructions to learn how:

Step 1

Use the cursor to select the cell or cells you want to highlight.

If you want to select an entire range, click and drag across the range you want to highlight till all the cells are selected and highlighted blue.

Step 2

Click on the Fill Color icon in the toolbar to open the fill color menu and select a color to highlight the cells. Be sure to choose a color where the text is still legible

Step 3

Your cells will immediately highlight the color you selected

If you need to update the cell highlight color later, simply follow the above steps and select a different color from the fill color menu.

You can also select the Reset option at the top of the fill color menu to remove the highlight.

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to highlight cells in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

More ways to do conditional formatting Google Sheets:

• Remove Conditional Formatting
• How To Do Conditional Formatting
• Copy Conditional Formatting
• Conditional Formatting Based On Another Cell
• Conditional Formatting for Duplicates
• Conditional Formatting with a Checkbox
• Conditional Formatting with Multiple Conditions
• Conditional Formatting Based On Another Sheet
• Apply Conditional Formatting Across An Entire Row
• Conditional Formatting to Compare Two Columns
• Conditional Data Validation
• Color Scale Based On Another Cell
• Relative Reference
• Conditional Formulas
• Conditional Formatting Based On Another Cell Not Empty
• Conditional Formatting Based On Another Cell Date
• If Cell Contains Text in
• Highlight Duplicate Cells
• Make Negative Numbers Red

You might also like:

22 Ways to Format Text in Google SheetsHow To Count How Many Times A Word Appears in Google SheetsHow To Change Text To All Caps In Google SheetsHow to Fit Text to Cell in Google Sheets