Find Option replacement

E

erick-flores

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
 
J

J. Sperry

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