CommencerCommencez gratuitement

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)

Cet exercice fait partie du cours

<cours>Mise en forme conditionnelle dans Google Sheets</cours>
Voir le cours

Instructions de l’exercice

  • 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).

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice