How to build a search box with conditional formatting

https://exceljet.net/tips/how-to-build-a-search-box-to-highlight-data
In this video, we use conditional formatting to create an interactive search box to highlight data. This is a nice alternative to filtering, because the information you're looking is highlighted in context, and the search box checks multiple columns at the same time (using concatenation).

https://exceljet.net

Видео How to build a search box with conditional formatting канала Exceljet