This article describes how to go from a standard table...
...to a table where rows with specific text in their labels (e.g. Pepsi) are highlighted:
Method
- Select your table.
- In the toolbar, go to Automate > Browse Online Library > Plot/Chart > Color Rows Based on Row Label.
- Enter the label text to base the condition on.
- Select the appropriate color from the color picker.
- Press OK.