Forum Discussion
Solved
Find and Replace Highlight colour
When I'm using the Find and Replace function and hit find, Excel finds the cell but its very hard to see because of the highlighted colour. Is there a way to change the default colour? Thanks in adv...
- I understand your struggle now. I guess you will have to rely on the columns and row headers to help you detect the column and row of the active cell.
Option 2 is to use less vibrant colours in your cells.
Also, other people posted your request as an improvement idea for Excel. You can add your vote:
- https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/38326495-change-the-border-color-around-the-selected-cell
- https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/40316236-active-cell-border
- https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/42616582-improve-visibility-of-selected-cells
The view count might be higher because this topic can be found in other forums (old and new). I found some sites offering a macro-based solution, but even that is not a true solution without issues. By the way, I also found a site that suggested the Mac OS version of Excel solved this issue. Users can customize the color of the highlight of the border. **Since it was for Mac OS, I only skimmed the content. So I might have misread it.**
This is an Accessibility issue, which for whatever reason, MS is choosing to ignore.
Until the highlight color issue is resolved by Microsoft, for MS 365, try looking in the suspected column or row that you are searching. Look through the suspected cells until you find the cell that shows a small shaded square symbol in the lower right corner. This is the highlighted cell you are looking for. This procedure is only true while using the "find and replace" feature in Excel 365.
I agree that more should be done by Microsoft to show the highlighted cell more vividly, but until then, I believe this procedure will get you by.
