Collective Computing

interleaved rows in a Google Spreadsheet on PC or Mac

Sergio Caballero

17/11/2018 - Updated: 11/12/2018

How to highlight interleaved rows in a Google Spreadsheet on PC or Mac

With this wikiHow, you will learn how to use a custom formula to highlight or shade cells in odd or even rows in a Google spreadsheet, which is worked on in a web browser

Steps

  1. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 1
    1

    In a web browser, go to the Google Spreadsheets page. Type sheets.google.com in the address bar and press the key. Intro of the keyboard.
  2. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 2
    2

    Select the file you want to edit. Find the spreadsheet you need from the list of saved items and open it.
  3. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 3
    3

    Click on the tab Format. This is located in the toolbar below the spreadsheet title in the upper left corner. Doing so will open a drop-down menu.
  4. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 4
    4

    Click on the option Conditional formatting?. In this way, you will access the formatting panel, which will appear on the right side of the spreadsheet.
  5. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 5
    5

    Select the text box below "Apply to range". This is located at the top of the formatting panel on the right. By doing so, you will be able to select the area you want to edit and highlight.
  6. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 6
    6

    Select the area you want to edit in the spreadsheet. Press the first cell and drag the mouse pointer to select the area to edit.
    • When you click on a cell, a window saying "What data" will appear. In it, you can see the range of selected cells.
  7. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 7
    7

    Click on Accept. In this way, you will confirm the range of selected cells.
  8. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 8
    8

    Click on the drop-down menu below the Format Cells If... button. This is located in the center of the formatting panel on the right. When you open it, you will see a list of available formatting conditions.
  9. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 9
    9

    Scroll down and select the option The customized formula is. This way, you can add your own formatting formula.
  10. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 10
    10

    Click on the box that says Value or formula of the format panel. Here you can write your personalized formula.
  11. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 11
    11

    Write =ISEVEN(ROW()) in the selected box. In this way, all even rows of the selected range of sows will automatically be highlighted.
    • If the formula does not highlight the rows you want, try the option =ISODD(ROW()). Thus, the odd rows of the selected range of cells will be highlighted.
    • You can place the row numbers on the far left of the spreadsheet.
  12. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 12
    12

    Click on the color menu under "Formatting Style". The default color is green. When you do so, a pop-up window will appear where you can choose another color to highlight the rows.
  13. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 13
    13

    Choose one of the colors in the window to highlight the cells. When doing so, the selected rows in the spreadsheet will automatically change color.
  14. Image titled Highlight Every Other Row on Google Sheets on PC or Mac Step 14
    14

    Click on the button Ready. This is located at the bottom of the formatting panel. This will save the new formatting formula.
    • This button does not save the changes made to the spreadsheet, so make sure that they have been saved correctly before closing the file.

Leave a Reply

Go up

Cookies on this website are used to personalize content and ads, provide social media features and analyze traffic. More information