Office Settings & Configuration

How to Make Find Results Easier to See in Excel 365

Chanuka GeekiyanageChanuka Geekiyanage Nov 3, 2026 870 views

Question details

Users need a way to change the border color, thickness, or shading of matched cells when using the Find feature in Excel 365 to make results more visible.

How to Make Find Results Easier to See in Excel 365
Product
Excel 365
Device & OS
not provided
Scenario
Searching for specific data within a densely populated worksheet where the standard highlight is too faint to locate quickly.
Observed behavior
Excel 365 highlights Find results with a faint, light green border that cannot be natively customized in color or thickness.
Before you start

Please note that Excel does not provide a built-in setting to customize the color or thickness of the Find-result border.

Solution 1Recommended

Use the Pre-Selection Workaround

By selecting the entire worksheet before searching, the white background of the active found cell will stand out clearly against the gray shading of the selected area.

Since Microsoft has not provided a native way to alter the Find box highlight color, using selection shading provides the highest contrast possible for spotting your search results.

1
Select the entire worksheet

Click the small triangle in the top-left corner of your worksheet (between the column 'A' header and row '1' indicator), or press the Ctrl + A shortcut on your keyboard to highlight all cells.

2
Open the Find dialog

Press Ctrl + F to bring up the Find and Replace dialog box.

3
Search for your data

Enter your search term into the 'Find what' field and click 'Find Next'.

4
Locate the result

The found cell will remain white while the rest of the worksheet is shaded gray, making it much easier to identify at a glance.

Use the Pre-Selection Workaround
Feature Limitations: Because this is a limitation within Excel's core design, you can submit a feature request directly to Microsoft by navigating to File > Feedback > Send a Suggestion.
Free Microsoft Office alternative

Experience Better Data Visibility with WPS Office

If Excel's limitations are slowing down your workflow, try WPS Office. It's a lightweight, highly compatible alternative that offers excellent data visibility and a user-friendly interface for all your spreadsheet tasks.

  1. 1. Download the installer: Visit the official WPS Office website and click the free download button.
  2. 2. Install the software: Run the installer file and follow the simple on-screen instructions.
  3. 3. Open your files: Launch WPS Spreadsheet and seamlessly open your existing Excel documents.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight architecture ensures fast loading and smooth searching.Clean, high-contrast user interface makes data navigation intuitive.Completely free for standard daily spreadsheet tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Can I use conditional formatting instead of the Find tool?

Yes. If you need permanent or highly visible highlights, you can use Conditional Formatting (Home > Conditional Formatting > Highlight Cells Rules > Text that Contains). This allows you to apply strong background colors to cells matching your criteria, completely bypassing the faint green border.

Does changing the Office theme make Find results easier to see?

Switching to a different Office theme, such as Dark Mode (File > Account > Office Theme), alters the overall contrast of your workbook. While the green border itself doesn't change, the new contrast might make it slightly easier for some users to spot.

Is it possible to use a macro to change the Find highlight color?

You cannot change the native Find box border color even with macros. However, you can write a VBA script that searches for a specific value and temporarily changes the background color (Fill Color) of the cell it finds.