123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> General >> View Article

How To Highlight Alternate Rows In Google Sheets

Profile Picture
By Author: karen minton
Total Articles: 325
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Google Sheets is one of the best platforms to create spreadsheets and offers a high quality of life features. Quick style is not one of them. You can apply alternate colors to both the columns and rows in a spreadsheet by using conditional formatting. Here’s how to highlight alternate rows in Google Sheets.

alternative rows.jpg

Steps to Highlight Alternate Rows in Google Sheets

• Open the internet browser,

• Web browsers like Mozilla Firefox, Google Chrome, Internet Explorer, etc.

• Go to the Google Sheets site.

• Select Google Sheets by using Google Drive.

• Sign in to the Google account in case you are not signed in yet.

• In case you have opened that page by using Google Drive or Google Sheets, you have to launch or make a new spreadsheet,

• If you have already created a spreadsheet, then click twice on it.

• You need to follow the below-mentioned steps if you are creating a new spreadsheet through Google Sheets site:

1. Place the mouse cursor above the plus symbol.

2. This symbol is located at the end right-hand side.

3. Press on the Create new spreadsheet symbol.

• In case you are creating a new spreadsheet through Google Drive, then follow the steps mentioned below:

1. Press on the + NEW option.

2. This option is located on the left-hand corner of the menu list.

3. Choose Google Sheets by going to the pull-down menu.

• Press on the Format option.

• You will get this option from the menu at the upper side of the display.

• It will open the option named as “Conditional format rules” from the right-hand side of the display.

• Type the conditions in the input sections on the basis of what you are trying to pull out. Go through the information of each section:

1. Format cells if: It is an option which helps you to select a particular cell which is formatted with the selected formatting settings. Press on the checkbox. By going to the pull-down list, choose the “Custom formula is” option.

2. Formatting style: In this option, you can select the fonts and colors of the alternate rows. You can do changes where you want to. In case you don’t have any problem with the default setting, then you don’t need to make any changes.

3. Apply to the range: Select the cells from which you will get the alternative colors that you can apply. Press on the input section and choose the cell. Otherwise, choose the cell range, or you can type the value manually.

4. Value or Formula: Here, you will get the “IF” formula. Select the “Custom formula is” option. You have to type the formula in the given box. For adding the colors to each row, type =ISEVEN(ROW()) in the given box.

5. After filling all the boxes, press on the Done option.

6. This option is located at the end for saving the changes you have made in the settings tab.

Source :- http://i-mcafee.com/how-to-highlight-alternate-rows-in-google-sheets/

More About the Author

I am a Blogger and Designer .My interests range from technology to design. I am also interested in programming and education.

Total Views: 174Word Count: 551See All articles From Author

Add Comment

General Articles

1. What To Keep In Mind While Buying A Commercial Security Door For Your Business
Author: GVA Garage Doors

2. Support Akshaya Patra’s Covid-19 Relief Services On World Hunger Day
Author: Akshaya Patra

3. Sandalwood Cultivation- Witnessing A Huge Growth In The Market
Author: navyanavvi

4. Advantages Of Hiring A Professional Electrician
Author: New Revelation Technologies

5. Why A Powerful Sewer Cable Machine Matters
Author: Lori Troyer

6. Increasing Funding Driving Blockchain Technology In Healthcare Market
Author: Pramod Kumar

7. The Soul Planet Of Mind Power
Author: Sagar Institute of Research & Technology

8. 3 Seo Topics That Any Website Owner Needs To Know!
Author: Thomas Decker

9. Angularjs Training - Free Online Demo
Author: Jovi Soft Solutions

10. Pick Up A Pair Of These Mens Boots In Size 15

11. Hospital Quality Management Course
Author: ssodl pune

12. 5 Little-known Tips To Complete Online Quran Courses Successfully
Author: Studio Arabiya

13. Twitter Now Lets You Schedule Tweets From Its Web App
Author: karen minton

14. Major Materials Used In Medical Implants
Author: Prasad Ugale

15. Best Ways To Select The Cheapest Packers And Movers In Noida
Author: Sunita Kumari

Login To Account
Login Email:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: