View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
J. Sperry[_2_] J. Sperry[_2_] is offline
external usenet poster
 
Posts: 33
Default Find Option replacement

You can use conditional formatting, so that everything equal to B2 is shaded
a certain color.

"erick-flores" wrote:

Hello all

Is it possible to have in cell B2 the option to Find something in the
entire worksheet?

Just like Ctrl+F, but I do not want to press Ctrl+F....I just want to
be able to directly type what i am trying to find in B2 and get the
same results as Ctrl+F

thanks in advance