ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find and replace results can the appearance of find be different? (https://www.excelbanter.com/excel-discussion-misc-queries/246609-find-replace-results-can-appearance-find-different.html)

LLS at DPW

Find and replace results can the appearance of find be different?
 
Using find and replace -- Can the results of the find be highlighted
differently?


Dave Peterson

Find and replace results can the appearance of find be different?
 
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).

LLS at DPW wrote:

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


--

Dave Peterson

Gord Dibben

Find and replace results can the appearance of find be different?
 
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
wrote:

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




All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com