Automating "Find"

[Davidns]

Does anyone have a suggestion on how I could create a situation where clicking on a particular word in a cell initiates a Find for that word? I have a list of customers and it would be helpful to be able to click on a particular customer and then see all the other locations in my workbook that mentions that customer.

Thanks!

 

[popipipo]

You can use this conditional formula for it.
Put the word you want to find in Cel J1

=(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1);UPPER($J$1);"")))/LEN($J$1)>=1

 

[Davidns]

Sorry, but not quite following the formula. Can you explain what it does? Again, I am just looking for a way to click on a word in a cell and have that generate a search for other instances of that word in the workbook. Thanks!