Excel Find and Replace: Change Cell Fill Color

Yes. In Excel for Microsoft 365 on Windows, press Ctrl+H, open Options, choose a fill format beside Format for Find what, choose the new fill beside Format for Replace with, and select Replace All. Leave both text boxes blank to search by formatting alone; Excel will change the cell fill color without replacing cell contents.

What Find and Replace means by highlight color

Excel does not have a separate cell highlighter tool like the marker in Word. What people commonly call a cell’s highlight color is its fill color, applied from Home > Fill Color. Find and Replace can search for cells with a particular direct format and replace that format with another one, including a different fill color.

This distinction matters because a cell’s visible color may come from different sources. A manually applied fill is direct formatting. A color displayed by a conditional formatting rule is the result of that rule, not necessarily the cell’s stored fill. Find and Replace is useful for changing manual fills, but it is not a way to rewrite the rules that conditionally color cells.

You can also combine a format criterion with text. For example, you could search for cells containing the word Pending that also have a red fill, then replace the fill with yellow. If you want to recolor every cell with a particular fill regardless of its value, leave the text criteria empty and set only the format criterion.

Change a fill color with Find and Replace

Use the Replace tab in the Find and Replace dialog. The Find what side describes which cells to locate; the Replace with side describes the format to apply. On Windows, open the dialog with Ctrl+H, then select Options if the additional settings are not already visible.

Decide whether to search the whole sheet or only a particular range. To restrict the operation to a range, select that range before opening Find and Replace.
On the Find what side, leave the text box empty if color is the only criterion. Select Format beside it, then choose Format from the dialog. On the Format Cells window, open the Fill tab and select the current color you want Excel to find. Confirm the choice.
On the Replace with side, leave the text box empty for a format-only change. Select its Format button, open the Fill tab, and choose the destination color. Confirm the selection.
Check the dialog options, especially Within, to make sure the search is limited to the intended sheet or workbook. Select Replace All to change every match, or Find Next and Replace to review matches one at a time.
Read Excel’s replacement count, then inspect several changed cells. If the result is not right, use Ctrl+Z immediately to undo the replacement.

The exact labels may appear in a compact dialog until Options is expanded. The format choices are made through Format Cells, so you can select a standard theme color or a color from the available custom color controls. Choose carefully: a theme color can look different if the workbook’s theme changes later.

Search by format only or by text and format

For a color-only operation, the Find what text box can remain blank as long as a find format is specified. The Replace with text box can also remain blank if a replacement format is set. This tells Excel to match the formatting condition and apply the new formatting, rather than to exchange one piece of text for another.

To restrict the color change to certain text, enter the text in Find what and also set the find format. For instance, to recolor cells containing the exact text Review that currently have a light-red fill, enter Review and specify that fill. Set the replacement fill to light yellow. Excel will not recolor cells with different content just because they happen to use the same red fill.

Be precise about text matching. Options such as Match case and Match entire cell contents affect text searches. If Match entire cell contents is on, a cell containing Review required will not match the search term Review. If it is off, a cell may match when the searched text appears within a longer entry. These text options do not replace the need to set a format criterion when the color is part of the search.

Limit the search to the right cells

A color replacement can affect many cells, so check the search scope before you select Replace All. In the expanded dialog, Within lets you choose Sheet or Workbook. Sheet is the usual choice when you are working on one tab; Workbook searches across the workbook’s sheets and can make a much broader change than expected.

You can select a range first if the operation should be limited to a block, such as a status column or a table. Before replacing, make sure the selected range is correct and that Excel has not retained a different search scope or format from an earlier operation. A quick test with Find Next is a sensible way to see whether the first match is in the expected area.

Hidden rows and filtered lists deserve a check, too. A search is not simply the same as selecting visible cells only. If the requirement is specifically to change visible filtered records and leave hidden records alone, use an approach designed around visible cells rather than assuming Find and Replace will respect the filter as a visual boundary. Confirm the results in the worksheet before sharing or saving the workbook.

What changes, and what stays the same

A format-only replacement changes formatting, not the cell’s value or formula. If a cell contains 125 or a formula such as a total, changing its fill does not replace that content. However, if you type a value into Replace with, you are asking Excel to replace content as well as any specified format. Leave the text box blank when the goal is strictly a color change.

The Format Cells dialog can include more than fill. If you configure font, number, alignment, or border settings, those criteria may also affect what Excel finds or what it applies. For a fill-only task, set only the Fill options on both sides. This helps prevent a color cleanup from unexpectedly changing number formats, borders, or font styles.

Replace All changes all matches in its scope in one operation, and Excel reports how many replacements it made. That count is useful but does not prove the result is correct: a stale format criterion can produce zero matches, while a too-broad criterion can alter more cells than intended. Review a few examples and compare them with the original requirement.

Common problems and how to fix them

Replace All finds zero cells: Confirm the Find what format is set to the exact fill used in the worksheet. A similar-looking theme shade may be a different color. Also check that no old text criterion is still present and that Within points to the intended sheet or workbook.
Cells with the wrong color change: Clear unnecessary search criteria, verify the selected range, and check whether the workbook scope is set to Workbook. If you entered text, review Match case and Match entire cell contents.
The displayed color does not change: The appearance may be controlled by conditional formatting. Select an affected cell and inspect Home > Conditional Formatting > Manage Rules to see whether a rule applies. Change the rule or its formatting if that is what controls the displayed color.
The result has an unwanted font or border change: Reopen the Format choices and remove criteria that are not part of the task. Clear an old find format before setting the desired fill if the dialog may be carrying over settings from a previous search.
Replace All changes too much: Press Ctrl+Z promptly to undo, then repeat with a narrower selection or the correct sheet scope. Avoid making unrelated edits after the replacement if you may need to undo it, because undo reverses later actions first.

Find and Replace can retain format settings between uses, so a dialog that looks like a simple text search may still have a format condition attached. If results are surprising, inspect both Format settings instead of assuming they are clear.

When conditional formatting is a better alternative

Use conditional formatting when the color should communicate a changing condition rather than serve as a one-time manual label. For example, if overdue items should always appear red based on a due date, a rule can update the displayed color when dates or values change. Find and Replace merely applies a formatting change to matches at that moment; it does not establish a rule that keeps colors synchronized with future data.

To inspect or edit rules in Excel for Microsoft 365 on Windows, select a relevant cell and go to Home > Conditional Formatting > Manage Rules. The rules manager helps identify which cells a rule applies to and what format it uses. If several rules overlap, their order and settings can affect what color appears, so changing the cell’s manual fill may have no visible effect while a rule is active.

For a one-time cleanup of manually colored cells, Find and Replace is often quicker. For color based on a status value, date, threshold, or formula, conditional formatting is usually more maintainable. If you simply need to color a few unrelated cells, selecting them and using Home > Fill Color may be clearer than setting up a search.

Excel for Mac and Excel for the web

On Excel for Mac, open the Replace dialog from the Edit or Home interface; the precise menu placement can vary by release. The format-based method is the same in principle: set the find format, set the replacement format, and run Replace All. Keyboard shortcuts can differ by keyboard and Excel release, so use the menu command if Ctrl+H does not open the dialog on your Mac.

Excel for the web has a more limited Find and Replace experience than the desktop application and may not provide the same format-search controls. If you need to replace cell formatting by fill color and cannot find Format options in the web dialog, open the workbook in the desktop version of Excel and perform the operation there. Avoid substituting a text replacement when the intended criterion is a color.

Frequently Asked Questions

Can Excel Find and Replace change only the cell color?
Yes. Set a find format and a replacement format, and leave the Find what and Replace with text boxes blank. In the Format Cells choices, set only the Fill options if you do not want to affect other formatting.

Can I find a color and replace it with another color without changing text?
Yes. Use a format-only search and a format-only replacement. Do not enter replacement text. Excel changes the matching cell formatting while preserving values and formulas.

Why does Find and Replace not change a color applied by a rule?
Conditional formatting controls the displayed appearance when its rule applies. Find and Replace changes direct cell formatting, not the logic or format of the conditional formatting rule. Edit the rule through Home > Conditional Formatting > Manage Rules.

Can I change the color only in one column or range?
Select the range before opening Find and Replace, then confirm the intended scope and test with Find Next. Check the first few results before using Replace All so you know the operation is confined as expected.

How do I undo a color replacement?
Use Ctrl+Z on Windows immediately after the operation. Undo works for a replacement action, but it is safest to verify the change before continuing with other edits. If the workbook is important, save a copy before a large-scale formatting change.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.