How To Highlight in Excel Like a Pro

Yes, you can highlight in Excel. Select the cells, then click Home, Fill Color to apply a background color. To color part of the text inside a cell, double-click the cell, select the words, and use Font Color. To highlight automatically, use Home, Conditional Formatting.

Last updated: August 25, 2026

Do you need to make important data stand out in your Excel spreadsheet?

Microsoft Excel lets you highlight cells, rows, and columns in several different ways, so you can emphasize important numbers, flag errors, or sort information into categories.

This guide covers every method, from a one-click fill color to conditional formatting rules that recolor your sheet on their own. It also answers the two questions people ask most often and rarely find a straight answer to: whether you can highlight part of the text inside a single cell, and why the highlight button sometimes refuses to work.

What This Guide Covers

• Can you highlight text in Excel?
• Highlighting cells using fill color
• How to highlight a column, a row, or multiple cells
• How to highlight the row and column of the selected cell
• Creating and using custom cell styles
• Using conditional formatting for dynamic highlighting
• Highlighting specific text within a cell
• How to remove highlighting or gray out cells
• Why can't I highlight in Excel?
• Keyboard shortcuts for quick highlighting
• Tips and best practices
• FAQ

Can You Highlight Text in Excel?

Yes. Excel gives you two different things that people both call highlighting, and knowing which one you want saves a lot of clicking.

• Highlighting a cell means filling the whole cell with a background color. That is the Fill Color button on the Home tab.

• Highlighting text inside a cell means formatting only some of the characters in that cell. Excel has no text highlighter pen like Word does, so you do this by changing the font color of the selected characters instead.

So if you have been hunting for a yellow highlighter pen on the ribbon and cannot find one, you are not missing it. It does not exist in Excel. Fill Color colors the cell, Font Color colors the characters.

Rule to remember: in Excel, Fill Color changes the cell background, Font Color changes the characters. There is no highlighter pen tool.

Highlighting Cells Using Fill Color

A quick way to make data stand out in Excel is to highlight cells using fill color. This method applies a background color to whichever cells you have selected, so you can spot them at a glance. Here's how to do it in two stages:

Stage 1: Selecting cells to highlight.

Before applying a highlight, you need to select the desired cells. You can highlight:

• An individual cell by clicking on it.

• A range of cells by clicking and dragging.

• An entire row or column by clicking the row number or column letter.

• Non-adjacent cells by holding Ctrl (Windows) or Cmd (Mac) while selecting.

Stage 2: Applying fill color.

To highlight using fill color:

1. Go to the Home tab on the Excel ribbon.

2. Click the Fill Color icon (paint bucket symbol) in the Font group.

   

3. Choose a color from the drop-down palette.

   

Rule to remember: Fill Color is static. It stays where you put it even if the data changes. If you want the color to follow the data, you need conditional formatting instead.

Read more: How to alternate row colors in Excel.

How to Highlight a Column, a Row, or Multiple Cells in Excel

Most of the time the slow part is not applying the color, it is selecting the right cells first. These are the selections people ask about most, and the fastest way to make each one.

How do I highlight an entire column in Excel?

Click the column letter at the top of the column, or click any cell in the column and press Ctrl + Space. The whole column is selected, and any fill color you apply now covers all of it. To select several columns at once, click the first column letter and drag across, or hold Ctrl and click each column letter you want.

How do I highlight an entire row in Excel?

Click the row number on the left, or click any cell in the row and press Shift + Space. Hold Ctrl and click additional row numbers to add more rows to the selection.

How do I highlight multiple cells that are not next to each other?

Select the first cell or range, then hold Ctrl (Cmd on a Mac) and click or drag the others. Everything you pick stays selected, and one click of Fill Color colors all of them together.

How do I highlight all the cells that contain data?

Click any cell inside your data and press Ctrl + A. That selects the current block of data. Press Ctrl + A a second time to select the entire worksheet. To select from your current cell out to the last cell that contains anything, press Ctrl + Shift + End.

Selection shortcuts at a glance

Rule to remember: Ctrl + Space grabs the column, Shift + Space grabs the row. Press both together and you have selected the whole sheet.

How to Highlight the Row and Column of the Selected Cell

On a wide sheet it is easy to lose track of which row you are reading. Excel can shade the row and column of whatever cell you are sitting on, so the active cell sits in a crosshair.

The built-in way: Focus Cell

1. Go to the View tab.

2. Click Focus Cell.

3. Move around the sheet. The row and column of the active cell stay shaded, and the shading follows you.

Prerequisite worth knowing: Focus Cell is a Microsoft 365 feature. If your View tab has no Focus Cell button, you are on a perpetual version such as Excel 2021 or Excel 2019, and this option is not available to you. Nothing is broken, the feature simply is not in that build.

Why the popular formula trick does not work on its own

You will find advice online telling you to add a conditional formatting rule using =CELL("row")=ROW() to shade the active row. Be aware of what that actually does before you spend time on it. Moving the cursor from one cell to another is not a calculation, so Excel does not recalculate the rule, and the shading stays stuck on the row where it was last recalculated until you press F9 or edit a cell.

Making it follow the cursor properly needs a small macro in the worksheet module that forces a recalculation whenever the selection changes, which in turn means saving the file as a macro-enabled workbook (.xlsm) and having macros enabled when it opens. If you are on Microsoft 365, Focus Cell does the same job with no macro and no file format change.

Rule to remember: highlighting that follows your cursor is not a formula problem. Selecting a cell does not trigger a recalculation, so either use Focus Cell or accept that you need a macro-enabled file.

Creating and Using Custom Cell Styles for Highlighting

If you frequently use a specific highlighting style, you can create a Custom Cell Style to save time. This method ensures consistency in formatting across large datasets. See how to create a new style below:

Stage 1: Create a custom cell style.

1. Open Excel and select a cell that you want to format.

   

2. Go to the Home tab and click Cell Styles in the Styles group.

   

3. Click New Cell Style at the bottom of the dropdown.

   

4. Enter a descriptive name in the Style Name box (e.g., “Highlight - Important”).

   

5. Click the Format button, and in the Format Cells dialog box, customize:

   • Fill (choose a background color for highlighting)

   • Font (change text color, bold, or italicize if needed)

   • Borders (add borders for better visibility)

     

6. Click OK, then OK again, to save the style.

   

Stage 2: Apply the custom cell style.

1. Select the cell(s) you want to highlight.

2. Go to the Home tab, click Cell Styles, and choose your newly created style.

   

Rule to remember: a custom cell style is saved with the workbook, not with Excel. Copy a cell that uses the style into another workbook to carry the style across.

Utilizing Conditional Formatting for Dynamic Highlighting

Conditional formatting tells Excel to color cells on its own, based on rules you set. For example, you can have every value over 100 turn red without touching them again. Microsoft documents the full feature set in its guide to using conditional formatting to highlight information. Here are the four rules that cover most real spreadsheets.

Example 1: Highlight based on cell value.

If you want to highlight cells that meet a specific condition (e.g., values greater than 100):

1. Select the range of cells you want to format.

   

2. Go to the Home tab and click Conditional Formatting in the Styles group.

   

3. Choose Highlight Cells Rules, then select a rule like:

   • Greater Than… (e.g., highlight values over 100)

   • Less Than…

   • Equal To…

   • Between…

     

4. Enter the value and choose a formatting style (color, bold, etc.).

   

5. Click OK. Excel will highlight cells meeting the condition automatically.

   

Example 2: Use a formula to highlight cells.

For more advanced highlighting, you can use a formula:

1. Select the range where you want the rule applied.

2. Go to Home > Conditional Formatting > New Rule.

   

3. Select Use a formula to determine which cells to format.

4. Enter a formula (e.g., to highlight values greater than 15 in column E: =E2>15).

   

5. Click Format, choose a custom color, and click OK.

   

Result:

The dollar signs matter more than anything else in that box. A formula rule is written for the top-left cell of the range you selected, then copied to every other cell in that range, exactly like filling a formula down and across. Lock the wrong part of the reference and every cell in the range formats off one single cell.

Rule to remember: write the formula as if it applies to the top-left cell of your range, and lock only the part that must not move.

Example 3: Highlight duplicate values.

As an Excel user, you don't need to go through the stress of finding duplicate cells manually. To quickly find duplicates in Excel:

1. Select the range of data.

2. Go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

   

3. Choose a formatting option and click OK.

   

Result:

Example 4: Automatically highlight cells based on text.

The rules above are built for numbers. Coloring cells because of what they say is just as common, and it is the case the Highlight Cells Rules menu handles least well. There are three versions of this, and they need three different approaches.

To color a cell that contains a word anywhere inside it, select the range and go to Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. Type the word and pick a format. This catches partial matches, so "Urgent" matches the cell "Urgent review needed".

To color a cell only when it matches a word exactly, use a formula rule instead, because Text that Contains will not do exact matching. Select your range, choose New Rule, Use a formula to determine which cells to format, and enter this, assuming your range starts in cell B2:

=B2="Complete"

To color an entire row based on one column's text, select the whole data range, for example A2:F200, and use a formula rule with the column locked and the row left free:

=$D2="Overdue"

Every cell in a row now checks column D of its own row, so the full row colors together. This is the single most useful conditional formatting rule most people never set up.

If you need a partial match to drive a whole row, wrap a search inside ISNUMBER so the rule returns TRUE or FALSE rather than an error:

=ISNUMBER(SEARCH("overdue",$D2))

SEARCH is not case sensitive, so it finds "Overdue", "overdue" and "OVERDUE" alike. Swap in FIND instead of SEARCH if you need the match to respect capitalization. ISNUMBER is not decoration here: on its own, SEARCH returns the #VALUE! error when the word is missing, and a rule built on a raw SEARCH is fragile.

For rules that read a value out of a completely different cell, see our full guide to conditional formatting based on another cell.

Rule to remember: Text that Contains handles partial matches on single cells. Anything involving an exact match, or coloring a whole row, needs a formula rule.

Highlighting Specific Text Within a Cell

If you need to emphasize part of a text within a cell, you can change the font color. You can highlight key terms within long text entries.

1. Double-click the cell to enter edit mode.

2. Select the text you want to highlight.

   

3. Go to the Home tab and click the Font Color icon.

   

4. Choose a color from the palette.

   

Can a formula highlight specific text inside a cell?

No, and this is worth being direct about because a lot of time gets lost here. Conditional formatting and worksheet formulas can only format a whole cell. Neither one can color, bold, or underline a few characters inside a cell and leave the rest alone. Formatting part of a cell's text is manual character formatting, which is why the steps above involve double-clicking into the cell and dragging over the words.

If you need it applied across hundreds of rows, the only route is VBA, which walks each cell and sets the font color of a specific character range. That requires the file to be saved as a macro-enabled workbook (.xlsm) with macros enabled, so weigh it against restructuring the data. Splitting the keyword into its own column and coloring that column with a normal conditional formatting rule is usually faster and easier to maintain.

Rule to remember: formulas format whole cells only. Coloring part of the text inside a cell is manual formatting or VBA, never a formula.

How to Remove Highlighting or Gray Out Cells in Excel

Removing a fill color

Select the cells, go to the Home tab, click the Fill Color icon, and choose No Fill. The keyboard route is Alt + H + H + N.

If the color refuses to go away, it was not a fill color to begin with. It was a conditional formatting rule, and No Fill cannot touch it. Go to Home > Conditional Formatting > Clear Rules and choose to clear rules from the selected cells or from the entire sheet.

Graying out cells

Graying out is the same fill technique with a specific intent, marking cells as inactive or not applicable rather than important. Select the cells, click Fill Color, and pick a light gray from the top row of the palette. Dim the text as well with Font Color set to a mid gray, and the cells read as switched off instead of merely colored.

To gray out cells automatically, for example every row already marked complete, use a conditional formatting rule such as =$D2="Complete" with a gray fill, following the whole-row method above.

Rule to remember: No Fill removes manual color only. Color that survives No Fill is conditional formatting, and it is removed under Clear Rules.

Why Can't I Highlight in Excel?

If the fill color will not apply, or the color you apply does not show, one of a small number of things is almost always responsible.

Rule to remember: if a cell will not change color, check for a conditional formatting rule before you check anything else. Rules override manual fill every time.

Keyboard Shortcuts for Quick Highlighting

If you are in a hurry, you can highlight in Excel with keyboard shortcuts. Here are some shortcuts to speed up your workflow:

Rule to remember: apply a color once, then press F4 on the next selection to repeat it. It is the fastest way to color scattered cells the same shade.

Tips and Best Practices for Highlighting in Excel

Highlighting makes a spreadsheet easier to read right up until it does not. A few habits keep it useful:

1. Use contrasting colors to ensure visibility.

2. Avoid over-highlighting, as excessive color can reduce readability.

3. Stick to a color scheme for consistency in reports.

4. Use conditional formatting for automated highlighting to reduce manual effort.

5. Do not rely on color alone. Some readers cannot reliably tell red from green, and color is lost entirely in a black and white printout, so pair a red fill with a word, an icon, or bold text and the meaning survives without it.

6. Prefer conditional formatting over manual fill on shared files. Manual color goes stale the moment someone edits the data. A rule cannot.

Final Thoughts

You can highlight information in Excel using basic fill color, custom styles, or conditional formatting. Manual fill is best for one-off notes, cell styles are best for repeated formatting you want consistent, and conditional formatting is best whenever the color should update itself as the data changes.

For more easy-to-follow Excel guides and the latest Excel Templates, visit Simple Sheets and the related articles section of this blog post.

Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials!

FAQ

How do I remove highlighting from a cell in Excel?

Select the cells, go to the Home tab, click the Fill Color icon, and choose No Fill. If the color stays, it is a conditional formatting rule rather than a fill, and you remove it under Home, Conditional Formatting, Clear Rules.

Can I highlight entire rows automatically based on a condition?

Yes. Select the whole data range, for example A1:D50, then go to Conditional Formatting, New Rule, Use a formula to determine which cells to format, and enter a formula like =$A1>100 to highlight rows where column A exceeds 100. Lock the column with a dollar sign and leave the row number free.

Is there a way to highlight duplicates in Excel?

Yes. Go to Conditional Formatting, select Highlight Cells Rules, and choose Duplicate Values to automatically highlight repeated entries.

How do I highlight an entire column in Excel?

Click the column letter at the top of the column, or click any cell in that column and press Ctrl + Space. Then apply a fill color from the Home tab.

Can you highlight only part of the text inside a cell?

Yes, but only by hand. Double-click the cell, select the characters you want, and change the Font Color. No formula or conditional formatting rule can format part of a cell, because both work on whole cells only.

Why is the Fill Color button grayed out in Excel?

The worksheet is protected or the file is open in Protected View. Go to Review, Unprotect Sheet, or click Enable Editing on the yellow bar at the top of a downloaded file.

Related Articles

How to Group Rows in Excel

How to Calculate Z-Score in Excel

How to Use Center Across Selection in Excel

Excel Conditional Formatting Based on Another Cell

How to Highlight Duplicates in Excel