$$Excel-Macros$$ How the excel searching the data in it

*Can anyone inform me how it works.. Thanks!* * * *With regards, **Pravin Gunjal** * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ How the excel searching the data in it

Hi Pravin It is not magic it is condtional formatting. The condition looks if a cell is the same as the search cell and colors it. On 17 August 2012 17:59, Pravin Gunjal wrote: > *Can anyone inform me how it works.. Thanks!* > * * > > *With regards, > **Pravin Gunjal** > * > > -- > Join

Re: $$Excel-Macros$$ How the excel searching the data in it

Hi Indrajit, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name & I search name then I scroll bar up & down which cell highlight. I want to jump that cell directly with highlight.Is it possible? Thanks Amar On Fri, Aug 17, 2012 at 5:02 PM,