Highlighting search

Now let's take that formula from the last lesson and use it as a custom formula for conditional formatting. This will bring your search to life.

Recall, the SEARCH function from the last exercise returns a number greater than 1 if it finds the string it is looking for and follows the following format:

SEARCH(search_for, text_to_search)

Ця вправа є частиною курсу

Умовне форматування в Google Sheets

Переглянути курс

Інструкції до вправи

Use the SEARCH function from the last exercise as a custom formula for conditional formatting that highlights the Vendor (rows 3 to 19) with the Default green background if the result is greater than 0.
- For the search_for criteria, fix the row with $ (e.g. E$3) but do not fix the column (e.g. $E$3).
- For the text_to_search criteria, select the Vendors, fixing only the rows (e.g. B$3:B$19).

Практична інтерактивна вправа

Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ

Почати вправу