How to Highlight Every Other Row on Google Sheets on PC or Mac

This wikiHow teaches you how to use a custom formatting formula to highlight all the even or odd-numbered cells in a Google Sheets spreadsheet with a color fill, using a desktop internet browser.

EditSteps

  1. Open Google Sheets in your internet browser. Type sheets.google.com into the address bar, and hit or on your keyboard.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 1.jpg
  2. Click the file you want to edit. Find the file you want to highlight in the list of your saved spreadsheet files, and open it.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 2.jpg
  3. Click the tab. This button is on a tabs bar below the file name in the upper-left corner of your spreadsheet. It will open a drop-down menu.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 3.jpg
  4. Click on the Format menu. This will open the formatting panel on the right-hand side of your spreadsheet.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 4.jpg
  5. Click the text field under the "Apply to range" heading. This field is at the top of the formatting panel on the right-hand side. It will allow you to select the area you want to edit and highlight.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 5.jpg
  6. Select the area you want to edit on the spreadsheet. Click your first cell, and drag your mouse to select the area you want to edit.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 6.jpg
    • When you click a cell, a new window titled "What data?" will pop-up. You can see your selected cell range in this pop-up window.
  7. Click in the pop-up. This will confirm your range selection.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 7.jpg
  8. Click the drop-down menu under the "Format cells if" heading. This option is in the middle of the formatting panel on the right-hand side. It will open a list of available formatting conditions.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 8.jpg
  9. Scroll down and select on the menu. This will allow you to type in a custom formatting formula.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 9.jpg
  10. Click the field in the formatting panel. You can type in your custom formula here.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 10.jpg
  11. Enter into the Value or formula field. This formula will highlight all the even-numbered rows in the selected cell range.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 11.jpg
    • If the formula above highlights the wrong set of rows, try . This will highlight all the odd-numbered rows in the selected range.
    • You can find all the row numbers on the left-hand side of your spreadsheet.
  12. Click the color menu under the "Formatting style" heading. The drop-down menu is green by default. This will open a pop-up window, and allow you to choose a different highlight color.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 12.jpg
  13. Select a highlight color in the pop-up window. Clicking a highlight color here will automatically apply it to your spreadsheet.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 13.jpg
  14. Click the blue button. This button is at the bottom of the formatting panel. It will save your new formatting formula.
    Highlight Every Other Row on Google Sheets on PC or Mac Step 14.jpg
    • This button doesn't save your changes to the spreadsheet file. Make sure you save all the changes before quitting.


from wikihow
via wikihow plus
Share on Google Plus

About wikiHow.com

    Blogger Comment
    Facebook Comment