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

L

LLS at DPW

Using find and replace -- Can the results of the find be highlighted
differently?
 
D

Dave Peterson

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).
 
G

Gord Dibben

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
 
Top