software

I would like to use the find function and have the results (cell) highlight
when found.

Um...huh?

Are you using the FIND function or the
Excel menu lt;Editgt;lt;Findgt; ?

The FIND function will never hilight other cells, but

lt;Editgt;lt;Findgt; does hilight the matched cells....
initially only one cell, but if there are more than one matched cells, they
list in the bottom of the dialog...just click in that section and Ctrl-A to
select (and hilight) all matches.Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Hermanquot; wrote:

gt; I would like to use the find function and have the results (cell) highlight
gt; when found.

Your right, I am using the lt;editgt;lt;findgt;, but I would like for the results to
be a different color, like red or blue so that it can be read easier. The
sheet being read is hundreds of rows and small fonts.

OR can it zoom in on the result ??

Thanks,
herman

quot;Ron Coderrequot; wrote:

gt; Um...huh?
gt;
gt; Are you using the FIND function or the
gt; Excel menu lt;Editgt;lt;Findgt; ?
gt;
gt; The FIND function will never hilight other cells, but
gt;
gt; lt;Editgt;lt;Findgt; does hilight the matched cells....
gt; initially only one cell, but if there are more than one matched cells, they
gt; list in the bottom of the dialog...just click in that section and Ctrl-A to
gt; select (and hilight) all matches.
gt;
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Hermanquot; wrote:
gt;
gt; gt; I would like to use the find function and have the results (cell) highlight
gt; gt; when found.