Search Function

[EMY245]

Hello,

I am not sure whether this is possible but ...

I would like to add a Search bar to an excel document, so that you can type in all (or part) of a word and it will search the sheet for matches - then either highlight the matches or move the cursor to those cells. The document is being used as a reference/index for customers and so i do not want them to have use a formula.

All i have found is the standard search function where you have to use the forumla to search and it returns a number value where this is a match but this will not work for what i am using it for.

Essentially, i want to create the 'Ctrl + F, Find' tool as an inbuilt cell - is this possible?!

Thanks in advance for any help!

Emily

 

[WarPigl3t]

Use conditional formatting. Have the formula equal the search value with a wild card before and after the search value. So let's say your search cell is A1. A user types their search value in A1. It turns all cells red when it finds them. I think the wildcard is a % sigh. So have your equation equal =%$A$1%
If that doesn't work try =%&$A$1&%