How to Make Find Results Easier to See in Excel 365
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.

- 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.
Please note that Excel does not provide a built-in setting to customize the color or thickness of the Find-result border.
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.
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.
Press Ctrl + F to bring up the Find and Replace dialog box.
Enter your search term into the 'Find what' field and click 'Find Next'.
The found cell will remain white while the rest of the worksheet is shaded gray, making it much easier to identify at a glance.

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. Download the installer: Visit the official WPS Office website and click the free download button.
- 2. Install the software: Run the installer file and follow the simple on-screen instructions.
- 3. Open your files: Launch WPS Spreadsheet and seamlessly open your existing Excel documents.

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.




