This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. 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.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 4,100 times.
This How.com.vn teaches you how to highlight or color alternating rows in a spreadsheet using Google Sheets for Android.
Steps
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.
- 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 screen. Every other row of the sheet is now an alternating color.Advertisement
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
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.