Updated: November 20, 2026

If you need to know how to highlight cells in Google Sheets, the fastest path is to use fill color for a single cell, a range, or an entire row or column. You can also set up conditional formatting so Sheets highlights data for you automatically when a value changes, a rule is met, or a duplicate appears. Once you know the few places where highlighting lives, you can work much faster without hunting through menus.

Highlight a Cell, Row, or Column

For a basic highlight, select the cell or range first, then use the fill color tool in the toolbar. This is the answer to how do I highlight in Google Sheets, how to highlight a cell in Google Sheets, and how to highlight a row in Google Sheets.

  1. Click the cell, drag across a range, or click the row number or column letter.
  2. Go to the toolbar and choose the paint bucket icon.
  3. Select a fill color.
  4. For a full row highlight, click the row number first, then apply the color.
  5. For a full column highlight, click the column letter first, then apply the color.

If you want to highlight a line in Google Sheets, selecting the entire row is the cleanest method. If you want to highlight data in Google Sheets without changing the whole sheet, select just the range you need and apply one color.

Highlight Text Inside a Cell

Google Sheets lets you highlight text in Google Sheets only at the cell level, not like word-by-word highlighting in a document editor. That means you can color the whole cell, but you cannot drag across individual words inside a cell and give them separate highlight colors.

When people ask about highlighting words

Questions like can you highlight words in Google Sheets, how to highlight a word in Google Sheets, or can you highlight text in Google Sheets usually refer to one of two things. Either they want the whole cell shaded because it contains a certain word, or they want the text color changed for the cell contents. For partial text styling inside one cell, Google Sheets does not support true word highlighting the way Google Docs does.

If you need one word to stand out, split the text into separate cells, or use a note, comment, or different formatting on the full cell.

Use Conditional Formatting to Auto Highlight Data

Auto highlight in Google Sheets is done with conditional formatting. This is the best answer for how to auto highlight in Google Sheets and how to highlight data in Google Sheets based on a rule, not manual clicks.

  1. Select the range you want formatted.
  2. Click Format, then Conditional formatting.
  3. Choose a rule such as “Text contains,” “Is equal to,” “Greater than,” or “Custom formula is.”
  4. Pick the fill color you want.
  5. Click Done.

Use this for overdue tasks, low stock, duplicate names, blank cells, or status labels. If your goal is highlighting in Google Sheets without repeating the same manual action every time, conditional formatting is the right tool.

Highlight duplicates automatically

To handle duplicate highlight Google Sheets requests, choose a range, open conditional formatting, and use a duplicate-focused rule. A simple custom formula for duplicates is =COUNTIF($A$2:$A,A2)>1 when you are checking column A starting at row 2. This colors every repeated entry in that range.

Use a fixed starting row if you have headers. If your data changes and new rows are added, keep the rule applied to a broad enough range so the highlighting continues to work.

Find and Highlight Matching Values

If you want how to highlight in Google Sheets based on text, numbers, or dates already in the sheet, use conditional formatting instead of manual selection. This is the fastest way to answer can I highlight in Google Sheets for specific values that repeat across a table.

Highlight by text or number

For text, use a rule like “Text contains” and enter the word you want. For numbers, use “Greater than,” “Less than,” or “Is between.” For dates, use a date rule or a custom formula tied to today’s date. That lets you highlight cells in Google Sheets when a row meets a condition, such as tasks due this week or sales above a target.

If you want a whole row to change color when one column matches a condition, apply the rule to the full row range and use a custom formula that checks one column only. That gives you a clear row highlight in Google Sheets without manually coloring each row.

Count Highlighted Cells in Google Sheets

Google Sheets does not count highlighted cells with a standard built-in formula, because fill color is formatting, not data. If you need to count highlighted cells in Google Sheets, the answer depends on how the highlighting was created.

If the highlight comes from conditional formatting

The best method is to count the same condition that caused the highlight. If cells are highlighted when they contain “Done,” use a count formula such as =COUNTIF(A:A,”Done”). If rows are highlighted by a formula rule, count the underlying rule instead of the color.

If the highlight was added manually

Manual fill colors cannot be counted directly with a standard formula. You need to use a script or reorganize the sheet so the highlighted state is stored as data, such as a status column. That is the practical way to make counting reliable in Google Sheets.

Remove or Duplicate Highlights

If you want to duplicate highlight Google Sheets formatting from one cell to another, copy the source cell and use Paste special then Format only. That moves the highlight without changing the content. You can also drag the fill handle if you want the same formatting applied across adjacent cells.

Clear a highlight

To remove a fill color, select the cells, click the paint bucket icon, and choose Reset or None if it appears in your version of Sheets. If the highlight comes from conditional formatting, delete or edit the rule under Format, then Conditional formatting. Otherwise the color comes back as soon as the rule runs again.

If you are asking how to highlight Google Sheets items faster, learn the difference between manual fill color and rule-based formatting. Manual highlight is best for quick visual marks. Conditional formatting is best for live data that changes.

Frequently Asked Questions

Can you highlight in Google Sheets?

Yes. You can highlight cells, rows, columns, and ranges with fill color. You can also set automatic highlighting with conditional formatting.

How do I highlight a word in Google Sheets?

You cannot highlight a single word inside a cell with a different background color. You can highlight the whole cell, split the text into separate cells, or change the text color for the cell contents.

How do I highlight a column in Google Sheets?

Click the column letter at the top, then choose a fill color from the toolbar. If you want the highlight to depend on a rule, apply conditional formatting to the full column range.

How do you highlight in Google Sheets without doing it manually every time?

Use conditional formatting. It highlights cells automatically when the rule you set is true, such as matching text, duplicate values, dates, blanks, or number thresholds.