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 में Conditional Formatting
अभ्यास निर्देश
- 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
इंटरैक्टिव व्यावहारिक अभ्यास
हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें
अभ्यास शुरू करें