Cant readliy see the FIND results? Is there a way to highlight bet

S

Schnoopus

When I run the FIND function, you have to search the screen to see what it
found. Is there a way to Highlight the results in a different color to
better locate the results?
 
G

Gord Dibben

Do you mean a multiple-return results?

After running the Find All command, hit CTRL + a in the "found" dialog box.

Then hit the "fill color" icon.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making "Change Highlighting" feature darker 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Find utility, highlighting answer 2
How do I convert shading to highlighting for specific colors 8
count number of repeats in a column highlight result 1
Excel Copy & Paste Issue ?? 5
How to modify and updte specific styles for specific paragraphs across the document 0
VBA to Find Word or Phrase then Highlight Entire Paragraph that Follows 5

Top