Find and Replace Colors in Excel: A Practical Guide

Yes. In Excel for Microsoft 365 on Windows, use Home > Find & Select > Find, open Options, and search for a cell’s formatting; for a color-only change, use Find All, select the matching cells, and apply a new color. Excel can also search and replace formatting, but Find All is the safer route when you want to preserve cell contents.

What Excel Can—and Cannot—Replace

Excel does not have a single command labeled “replace this color everywhere.” Instead, its Find and Replace tools can search for cell formatting, including fill and font color. You can find cells with a particular format and then apply a different one. The distinction matters: changing a cell’s fill is a formatting operation, while replacing its text or number changes the cell’s contents.

For example, if a workbook uses yellow fill to flag items that need review and you want those items to be blue, you can search for cells with yellow fill, select the results, and apply blue fill. Their text, formulas, and numbers remain as they were. By contrast, using Replace All without understanding the text criteria can overwrite contents as well as affect formatting. For a color-only task, find the cells first and recolor the selection rather than treating Replace All as a paint-bucket shortcut.

Excel can also show colors that do not come from a cell’s ordinary fill setting. Conditional formatting can change a cell’s appearance according to its value or a rule. A displayed red fill may therefore be produced by a rule rather than applied directly to the cell. That is a different kind of color change, covered below.

Find Cells by Fill Color on Windows

To locate cells by their ordinary background fill in Excel for Microsoft 365 on Windows, use the Find tab and search by format:

Open the worksheet and press Ctrl+F, or choose Home > Find & Select > Find. The Find and Replace dialog opens.
Select Options >> to show the additional search settings.
Choose Format beside the Find what box. If the dialog offers Choose Format From Cell, select it and click a cell with the fill you want to find. Otherwise, use the Format Cells dialog to specify the fill.
Check the format criteria before searching. In the Format Cells dialog, select the Fill tab and choose the intended color. Avoid selecting unrelated font, border, or number-format criteria unless those are part of what you want to match.
Choose Find All. Excel lists cells that meet the search criteria. Select the results so the matching cells are selected on the sheet, then close the dialog.
On the Home tab, open the Fill Color menu and choose the replacement color. The selected cells receive the new fill.

Find Next moves through matches one at a time; Find All is more convenient when you want to change several matches together. If you want to inspect each result before changing it, use Find Next and recolor only the cells you approve. A search with no matches can mean the selected format criteria are too specific, not necessarily that the color is absent.

Change Font Color Instead of Cell Fill

“Cell color” can mean the background fill or the color of the text. These are separate formatting properties. To locate text in a particular font color, set the search format’s Font tab rather than its Fill tab. To change the results, use Home > Font Color and choose a new color. Do not use Fill Color for this task: it changes the background, not the lettering.

Be precise about the search format. If you choose a sample cell that has yellow fill, bold text, and a particular font, the search may use more than just the fill as its criteria. That can make Excel miss other yellow cells with different fonts. When you want to match only color, open the format settings and specify only the relevant fill or font color. Clear any leftover criteria if a previous search used other formatting.

Use Replace Formatting Carefully

The Replace tab in Find and Replace includes format settings for the found cells and the replacement format. This can be useful when you also intend to replace matching text or other contents. However, it is easy to confuse a formatting match with a content replacement. A blank or overly broad text criterion may not mean “change formatting and leave every value alone.” Before choosing Replace All, check both the Find what and Replace with fields and understand what will happen to matching cell contents.

For a color-only change, the more cautious workflow is Find All, select the matches, and apply the new color from the ribbon. If you do use the Replace tab for a combined content-and-format task, try Find Next on a known example first. Confirm that the correct cell is found and that the proposed replacement does exactly what you intend before using Replace All across a worksheet.

When the Color Comes from Conditional Formatting

Conditional formatting applies visual styles when specified conditions are met. For instance, a rule might color values below a threshold red, or a color scale might shade a range according to relative values. The displayed color can change when a value changes even though nobody manually changed the cell’s fill.

If Find by format does not locate cells that look red or yellow, check the conditional formatting rules. Select the relevant cells, then choose Home > Conditional Formatting > Manage Rules. Review the rules and the range shown in Applies to. Depending on the rule, you can edit its format, adjust its scope, or remove it. Changing the ordinary fill of a cell may not produce the lasting result you expect while a conditional-formatting rule still controls its appearance.

Color scales and rules based on formulas can produce several visible colors across a range. In that situation, changing one manual fill color will not necessarily replace all the displayed colors. Edit the rule or the scale itself if the goal is to change the appearance generated by conditional formatting. If the rule is not obvious, inspect the applicable rules carefully before deleting or changing one; a rule may be serving as an important visual warning.

Search Scope, Themes, and Other Common Problems

Find and Replace can search the current sheet or, through the expanded options, the workbook. Check the Within setting before searching: a search limited to Sheet will not find matching cells on other worksheets. Searching the whole workbook may take longer and can return results from sheets you did not intend to change, so review the selection and worksheet context before applying a new color.

No cells are found: Confirm the search is set to look in the right worksheet or workbook, and check that the format criteria specify only the color you mean.
Too many cells are found: Remove unrelated format criteria, or search on the correct sheet rather than the entire workbook.
The color looks different: Theme colors and manually chosen standard or custom colors can look similar without being the same format. Choose the exact color when setting the search criteria.
The new fill seems to disappear: A conditional-formatting rule may be overriding the appearance. Inspect the rules that apply to the cell.
Some cells cannot be changed: Sheet protection or merged-cell layouts may restrict editing or make selection behave differently. Check protection and test the intended change on a copy if the workbook is important.

Before making a broad change, consider saving a copy of the workbook. Excel normally lets you undo a formatting change with Ctrl+Z, but later actions, closing the workbook, or some workflows can limit what you can undo. A copy is especially useful when the workbook has many sheets or complicated rules.

Excel for Mac and Excel for the Web

On Excel for Mac, the Find and Replace workflow is similar, though dialog layout and some labels can differ by release. Control+H opens Find and Replace in many Excel for Mac setups; Command+F opens Find. Use the dialog’s expanded options and format controls if available, then confirm the selected cells before applying a color from the Home ribbon. If a shortcut behaves differently on your Mac, open Find and Replace from the ribbon rather than relying on the shortcut.

Excel for the web has a more limited set of desktop features and dialog controls. If you cannot find a format-search option there, open the workbook in the desktop Excel app and use the Windows or Mac steps above. For conditional formatting in the web app, use the Conditional Formatting controls available on the Home tab; the available rule-management options can differ from desktop Excel.

Alternatives for Repeated or Specialized Tasks

If you only need to change a few cells, selecting them and choosing a color directly is usually faster than searching. For a large range with a clear rule—such as all values below zero—conditional formatting is often better than manually coloring cells. It updates as values change and records the reason for the color in a rule.

For recurring workbooks with consistent categories, consider using a dedicated status column, data validation, or conditional-formatting rules instead of relying only on colors. A text label such as “Review” is searchable and communicates meaning to readers who cannot distinguish colors easily. A color can still reinforce the label, but should not be the only way important information is conveyed.

Macros can automate highly specific formatting changes across many sheets, but they require extra care and may be blocked by security settings. They are usually unnecessary for a one-time recoloring task. If you consider automation, keep a separate backup and make sure the code targets the intended workbook, sheets, and color criteria.

Frequently Asked Questions

Can I replace a color without changing the cell’s text or value?
Yes. Use Find All to select cells matching the format, then apply a new fill or font color from the Home tab. This changes formatting while leaving cell contents alone.

Can Excel find cells that have a specific fill color?
Yes, in desktop Excel you can open Find and Replace, expand Options, and set a format criterion for the fill color. Use Find All to list the matches and select them together.

Why does Find by color miss cells that look the same?
The cells may not have identical formatting, or the visible color may come from conditional formatting. Search only by the relevant fill or font color, and inspect conditional-formatting rules if the appearance is rule-based.

Can I change all colors in a workbook at once?
You can set the search scope to Workbook and find matching formatting across sheets, but review the results carefully before recoloring them. If the colors come from separate conditional-formatting rules, those rules may need to be edited individually.

Does Find and Replace work for font color as well as fill color?
Yes. Specify the font color in the search format settings and use Home > Font Color to change the selected text color. Fill Color changes the cell background instead.

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.