How to Highlight Every Other Row on Google Sheets on Android

This wikiHow teaches you how to highlight or color alternating rows in a spreadsheet using Google Sheets for Android.

Method 1
Method 1 of 2:
Using the Alternating Colors Menu

  1. Image titled Highlight Every Other Row on Google Sheets on Android Step 1
    1
    Open Google Sheets. It's the green icon with a white outline of a spreadsheet inside. You'll usually find it in the app drawer.
  2. Image titled Highlight Every Other Row on Google Sheets on Android Step 2
    2
    Tap the spreadsheet you want to edit. Its contents will appear.
    Advertisement
  3. Image titled Highlight Every Other Row on Google Sheets on Android Step 3
    3
    Tap the gray box at the top-left corner of the spreadsheet. It's above the first row and to the left of the first column. This highlights the entire spreadsheet.
  4. Image titled Highlight Every Other Row on Google Sheets on Android Step 4
    4
    Tap the formatting icon. It's the “A” with several lines at the top the screen. This opens the formatting menu at the bottom of the screen.
  5. Image titled Highlight Every Other Row on Google Sheets on Android Step 5
    5
    Tap the CELL tab. It's at the top-right corner of the formatting menu.
  6. Image titled Highlight Every Other Row on Google Sheets on Android Step 6
    6
    Tap Alternating colors.
  7. Image titled Highlight Every Other Row on Google Sheets on Android Step 7
    7
    Type the range into the “Apply to range” field. If you want to apply alternating colored rows to the entire sheet you can skip this step, as the range is already filled in.
  8. Image titled Highlight Every Other Row on Google Sheets on Android Step 8
    8
    Tap whether your spreadsheet has a header or footer. For example, if you have a row at the top of the spreadsheet that contains column headings and should not be colored differently, make sure “Header” is switched to On.
  9. Image titled Highlight Every Other Row on Google Sheets on Android Step 9
    9
    Tap a color scheme. A preview will appear at the top of the screen.
  10. Image titled Highlight Every Other Row on Google Sheets on Android Step 10
    10
    Tap
    Image titled Android7done.png
    .     It's at the top-left corner of the menu. This saves your selection.
  11. Image titled Highlight Every Other Row on Google Sheets on Android Step 11
    11
    Tap
    Image titled Android7done.png
    .     It's at the top-left corner of the screen. Every other row of the sheet is now an alternating color.
    Advertisement

Method 2
Method 2 of 2:
Using Conditional Formatting

  1. Image titled Highlight Every Other Row on Google Sheets on Android Step 12
    1
    Open Google Sheets. It's the green icon with a white outline of a spreadsheet inside. You'll usually find it in the app drawer.
  2. Image titled Highlight Every Other Row on Google Sheets on Android Step 13
    2
    Tap the spreadsheet you want to edit. Its contents will appear.
  3. Image titled Highlight Every Other Row on Google Sheets on Android Step 14
    3
    Tap the gray box at the top-left corner of the spreadsheet. It's above the first row and to the left of the first column. This highlights the entire spreadsheet.
  4. Image titled Highlight Every Other Row on Google Sheets on Android Step 15
    4
    Tap the formatting icon. It's the “A” with several lines at the top the screen. This opens the formatting menu at the bottom of the screen.
  5. Image titled Highlight Every Other Row on Google Sheets on Android Step 16
    5
    Scroll down the menu and tap Conditional formatting. This opens the “Create a rule” screen.
  6. Image titled Highlight Every Other Row on Google Sheets on Android Step 17
    6
    Type the range into the “Apply to range” field. If you want to apply alternating colored rows to the entire sheet you can skip this step, as the range is already filled in.
  7. Image titled Highlight Every Other Row on Google Sheets on Android Step 18
    7
    Tap the “Format cells if…” drop-down menu.
  8. Image titled Highlight Every Other Row on Google Sheets on Android Step 19
    8
    Select Custom formula. It's the final option in the menu.
  9. Image titled Highlight Every Other Row on Google Sheets on Android Step 20
    9
    Type =ISEVEN(ROW()) into the blank.
  10. Image titled Highlight Every Other Row on Google Sheets on Android Step 21
    10
    Tap your preferred color for the alternating colored row. The top row of options will color the background of each cell, while the bottom row colors the text.
  11. Image titled Highlight Every Other Row on Google Sheets on Android Step 22
    11
    Tap SAVE. It's at the top-right corner of the screen.
  12. Image titled Highlight Every Other Row on Google Sheets on Android Step 23
    12
    Tap
    Image titled Android7done.png
    .     It's at the top-left corner of the screen. Every other row of the sheet is now an alternating color.
    Advertisement

You Might Also Like

Allow Apps from Unknown Sources on Android
How to
Allow Apps from Unknown Sources on Android
Remove the Emergency Call Button on Android
How to
Remove the Emergency Call Button on Android
Change Number of Rings on Android
How to
Change Number of Rings on Android
Check What Kind of Android Phone You Have
How to
Check What Kind of Android Phone You Have
Unlock an Android Tablet
How to
Unlock an Android Tablet
Change the Screen Resolution on Your Android
How to
Change the Screen Resolution on Your Android
Connect Android Phone to Computer
How to
Connect Android Phone to Computer
See if Someone Read Your Text on Android
How to
See if Someone Read Your Text on Android
Access the Clipboard on Android
How to
Access the Clipboard on Android
Switch to Portrait or Landscape Mode on Android
How to
Switch to Portrait or Landscape Mode on Android
Hide Apps on Android
How to
Hide Apps on Android
Check the RAM on Android
How to
Check the RAM on Android
Access a Shared Folder on Android
How to
Access a Shared Folder on Android
Boost Microphone Volume on Android
How to
Boost Microphone Volume on Android
Advertisement

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 3,314 times.
How helpful is this?
Co-authors: 3
Updated: May 25, 2021
Views: 3,314
Categories: Android
Advertisement