ExcelBanter - Highlight Search Results

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Highlight Search Results (https://www.excelbanter.com/excel-discussion-misc-queries/185169-highlight-search-results.html)

edo

Highlight Search Results

Using Excel, how does one chage the settings to all the search results to be
more evident...possibly highlighted?

Gord Dibben

Highlight Search Results

Once the cells are found under "Find all" you can SHIFT + down arrow in the
"found" dialog box which selects all the found cells on the sheet.

FormatCellPatterns. Pick a color.

Gord Dibben MS Excel MVP

On Fri, 25 Apr 2008 11:46:00 -0700, edo wrote:

Using Excel, how does one chage the settings to all the search results to be
more evident...possibly highlighted?

All times are GMT +1. The time now is 01:55 AM.