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 試算表的條件格式
練習說明
- Use the
SEARCHfunction from the last exercise as a custom formula for conditional formatting that highlights theVendor(rows 3 to 19) with the Default green background if the result is greater than0.- For the
search_forcriteria, fix the row with$(e.g.E$3) but do not fix the column (e.g.$E$3). - For the
text_to_searchcriteria, select theVendors, fixing only the rows (e.g.B$3:B$19).
- For the
