Excel Conditional Formatting: No Cells Were Found?

In Excel for Microsoft 365 on Windows, “No cells were found” usually means Go To Special could not find conditional-formatting cells in the range it searched. It does not prove that the worksheet has no conditional formatting at all: check the selection, then inspect the rules in Conditional Formatting Rules Manager.

What the message means

The message commonly appears after you choose Home > Find & Select > Go To Special > Conditional formats. This command selects cells that have conditional-formatting rules. If no qualifying cells exist in the area Excel searches, it has nothing to select and reports that no cells were found.

That is different from asking whether any cells currently look highlighted. A rule can be attached to a cell even when its condition is false, so the cell displays no special format right now. Conversely, a colored cell might have a regular fill applied with the Fill Color button rather than conditional formatting. Go To Special is looking for conditional-formatting rules, not simply colored cells.

The message is therefore usually a result of the command’s search scope, not a broken workbook. It can also help identify a useful distinction: selecting cells with conditional formatting and viewing or editing the rules are related tasks, but they are not the same operation.

How Go To Special searches

Go To Special looks for cells with conditional formatting in the current worksheet’s search area. If you start with one cell selected, Excel searches the worksheet. If you first select a range, Excel searches within that selection. A range that is too narrow—or a selection on the wrong sheet—can therefore produce the message even when rules exist elsewhere.

In the Conditional formats section of the Go To Special dialog, Excel offers two choices:

All selects cells with conditional formatting in the searched area.
Same selects cells whose conditional formatting matches the active cell’s formatting setup. The active cell matters, so click a cell that already has a rule before using this option.

If you want to find every rule on a worksheet, use All, and make sure the active sheet and search scope are appropriate. Choosing Same while the active cell has no conditional formatting can return no matches even though other cells on the sheet have rules.

Check the selection and sheet first

Before changing any rules, try the simplest checks. They resolve many cases without editing the workbook:

Click the worksheet tab where you expect the formatting to be.
Click a single cell, rather than leaving a small range selected.
Choose Home > Find & Select > Go To Special.
Select Conditional formats, choose All, and click OK.

If Excel selects cells, the earlier selection was likely limiting the search, or the Same option was too restrictive. If the message remains, inspect the rules directly. You can also test a known range: select the area where a colored result appears and repeat the command. When you deliberately select a range, remember that cells with rules outside it will not be included.

Also verify that the formatting is actually conditional. Select a cell that looks colored and inspect Home > Conditional Formatting > Manage Rules. A normal fill color will not appear as a conditional-formatting rule there. If the cell’s color was applied manually, Go To Special is behaving as expected.

Inspect rules in Rules Manager

For a broader view, open Home > Conditional Formatting > Manage Rules. In the Rules Manager, check the Show formatting rules for list. It may be set to Current Selection, which displays only rules relevant to the selected cells. Change it to This Worksheet to review rules associated with the active sheet.

Read each rule’s Applies to range. A rule might apply to a different block of cells than you expected, or its range might have been shortened after rows or columns were inserted, deleted, or copied. A rule can also cover a large area while the condition is currently false for every cell. In that case, the rule exists even though no special formatting is visible.

Rules Manager is useful when Go To Special finds nothing because it lets you inspect rule definitions and target ranges without relying on the visible appearance of the cells. It also helps distinguish a missing rule from a rule that exists but is aimed at the wrong range.

Why the rule may not look active

Conditional formatting changes a cell’s appearance only when its rule’s condition is met. For example, a rule that highlights values below 10 will not show a highlight for a cell containing 12. Go To Special can still find that cell if the rule applies to it; the lack of color does not mean the rule is absent.

Other reasons a rule may be hard to spot include:

The format is subtle. The rule may change font color, borders, or a data bar rather than adding an obvious fill.
Another rule affects the result. Multiple rules can apply to the same cell. Their order and settings, including Stop If True where available, can affect what you see.
The formula or comparison is not evaluating as expected. A relative cell reference can shift across the Applies to range, and text values that look like numbers may not behave like numeric values.
The visible color is manual formatting. A manually applied fill can resemble a conditional format but is not a rule.

To diagnose a formula-based rule, check the formula and the Applies to range together. A formula written for the top-left cell of a range may need relative or absolute references depending on whether the reference should move as Excel evaluates other cells. Avoid rewriting a rule until you have identified its intended range and logic.

Common causes and sensible fixes

When the message persists, use a small, careful troubleshooting sequence rather than clearing rules immediately:

Confirm the correct worksheet. Rules are associated with worksheet cells; a different sheet can have a different set.
Use All, not Same. Same is for matching the active cell’s conditional formatting, not for finding every rule.
Review the worksheet in Rules Manager. Set Show formatting rules for to This Worksheet and look at the listed Applies to ranges.
Check whether the appearance is manual. If there is no relevant rule in Rules Manager, inspect ordinary font, fill, and border formatting instead.
Correct only the range or rule that is wrong. In Rules Manager, edit the Applies to range or rule as needed. Keep a note of the original setup if the workbook is important.

Be cautious with Home > Conditional Formatting > Clear Rules. The clear commands remove rules from the selected cells or worksheet; they do not locate or repair a missing rule. Clearing formatting can remove intentional work, so use it only when you mean to delete those rules. Saving a separate copy before making broad changes is a sensible precaution.

Excel for Mac and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac also provides Go To Special and Conditional Formatting Rules Manager, though the route to Go To Special can vary with the Mac ribbon layout and version. Look for Go To Special in Excel’s Find or Go To controls, then choose Conditional formats. The key diagnostic remains the same: check whether you are searching a selection or the sheet, and review the rules for the worksheet.

Excel for the web has a more limited set of desktop editing and selection tools, and some Go To Special options may not be available in the same way. If you cannot locate the command or need to inspect complex rules, open the workbook in the desktop Excel app. Avoid assuming that a missing command in the web interface means the workbook has no rules.

Frequently Asked Questions

Does “No cells were found” mean my conditional formatting was deleted?
No. It means the particular Go To Special search found no matching cells in its scope. Check the active sheet, selection, and the Rules Manager before concluding that rules are gone.

Why does Excel show no cells when I can see colored cells?
The cells may have manual fill or font formatting rather than conditional formatting. They may also be outside the selected range. Check a colored cell in Rules Manager and try Go To Special with All.

Can a cell have conditional formatting if it is not highlighted?
Yes. A rule can apply to a cell while its condition is false, or it may change an aspect of appearance that is easy to miss. Check the rule and its Applies to range rather than judging only by color.

How do I find all conditional formatting on a worksheet?
Click a single cell on the worksheet, use Home > Find & Select > Go To Special > Conditional formats, and choose All. For an inventory of rules and ranges, use Rules Manager and set its display to This Worksheet.

Will clearing rules fix the message?
Usually not. Clearing rules deletes conditional formatting; it does not make Go To Special find cells. First identify whether the problem is the selection, the active-cell choice for Same, a manual format, or a rule with an unexpected Applies to range.

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.