Use conditional formatting to format even and odd rows
Network administration - Some users prefer to change the color of a row so that their spreadsheet becomes more readable, especially when there is a lot of data. However, sometimes the limitations can make the problem complicated or from the beginning you may think so. For example, you might think that changing colors for odd or even rows is more difficult than changing the color of the remaining rows, but you're wrong. By using conditional formatting, formatting even or odd rows becomes a simple task:
- To format only even rows, use the conditional formula = EVEN (ROW ()) = ROW ().
- To format only odd rows, use the following formula = ODD (ROW ()) = ROW ().
Here we will guide you through a sample example:
- Select the rows you want to format. To select the entire worksheet, click Sheet Selector (the gray box intersects between the row and the column headers).
- Click the Home tab.
- Click Conditional Formatting in the Styles group and select New Rule .
- From the Select A Rule Type list , select Use A Formula To Determine Which Cells To Format .
- In Format Values Where This Formula Is True field , enter = EVEN (ROW ()) = ROW ().
- Click Format .
- Specify the format available. For example, to change to red for all even rows, click the Fill tab and click Red , then click OK twice.
Note that all even rows are now red. To change colors for individual rows, you can repeat the steps above. In step 4, enter the formula = ODD (ROW ()) = ROW (). In step 6, select the color you like, such as blue as in our example. You should note, this technique is not only for changing colors but also for general formats.
You should read it
- 5 best alternatives for Microsoft Excel
- Guide to full Excel 2016 (Part 7): Format spreadsheet data
- Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets
- Test your understanding of Excel
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
- Add a checkbox to the Excel spreadsheet
- A guide to the full Excel 2016 (Part 12): Page formatting and spreadsheet printing
- Collection of Useful Microsoft Excel Shortcuts
May be interested
- Microsoft re-released the Outlook 2007 updatenearly a month after removing the outlook 2007 update due to connectivity and performance issues, microsoft has released a patch to correct its mistake in december 2010.
- 'Packed' Excel filemany readers require 'security' for excel files to solve their own problems so that they can 'distribute' professionally. the article will cover the steps to 'pack' and create the interface as a software in vb language and users must install or fill the cd key when opening the file.
- Instructions for converting table format in Word 2010 into textdid you know that in word 2010 there is a basic feature that allows users to easily convert table format data into text?
- Improved email performance with the Microsoft Word Mail Merge featurethe microsoft mail merge feature of the microsoft word editor is one of the great tools for people who often work with text, email ... in the following article, we will present some basic steps. to use and manage word 2010's mail merge wizard ...
- Great presentation in PowerPoint 2010powerpoint is one of the most strategic products of microsoft office and has been released to users since the first versions more than 20 years ago.
- Access and edit documents online with Zohoyou can access and use your documents with the help of the zoho online office suite.