Find and replace results can the appearance of find be different?

  • Thread starter Thread starter LLS at DPW
  • Start date Start date
L

LLS at DPW

Using find and replace -- Can the results of the find be highlighted
differently?
 
Depending on the version of excel you're using, maybe you use Replace to change
the value and the format (bold red may stand out more).
 
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


On Mon, 26 Oct 2009 13:44:01 -0700, LLS at DPW <LLS at
 

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

Back
Top