This wikiHow teaches you how to highlight or color alternating rows in a spreadsheet using Google Sheets for Android.
Steps
Method 1
Method 1 of 2:
Using the Alternating Colors Menu
-
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.
-
Tap the spreadsheet you want to edit. Its contents will appear.Advertisement
-
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.
-
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.
-
Tap the CELL tab. It's at the top-right corner of the formatting menu.
-
Tap Alternating colors .
-
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.
-
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.
-
Tap a color scheme. A preview will appear at the top of the screen.
-
Tap. It's at the top-left corner of the menu. This saves your selection.
-
Tap. 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
-
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.
-
Tap the spreadsheet you want to edit. Its contents will appear.
-
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.
-
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.
-
Scroll down the menu and tap Conditional formatting . This opens the “Create a rule” screen.
-
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.
-
Tap the “Format cells if…” drop-down menu.
-
Select Custom formula . It's the final option in the menu.
-
Type =ISEVEN(ROW()) into the blank.
-
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.
-
Tap SAVE . It's at the top-right corner of the screen.
-
Tap. It's at the top-left corner of the screen. Every other row of the sheet is now an alternating color.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Thanks to all authors for creating a page that has been read 4,334 times.
Advertisement