At this point, anything you modify in row '1' will be unaffected. Copy the above to your script Editor in google sheets and save it.Under Format rules, select Custom formula is. Then go to the menu: Format > Conditional formatting.
Highlight your data range, in this case, A2:C21 (omitting the header row). How To Highlight The Top 5 Values In Google Sheets Method 1: Use the LARGE Function. This will apply a basic alternate color scheme to each row of your data set and open the. After your data is selected, click Format > Alternating Colors. You can either do this manually or select a cell in your data set, and then press Ctrl+A to select the data automatically. To do so, open your Google Sheets spreadsheet and select your data.
