Hi is it possible to have a field on a spread sheet to act as a custom filter.

Ie you type in what you want to search the spread sheet for and it automaticaly filters locates and high lights what you are looking for. if it is possible has anyone got any examples