4 basic steps to color alternating lines in Microsoft Excel
When having to work with a long spreadsheet with numbers in Excel, the probability of being mistaken between the lines is very high. Therefore, to overcome this situation, we will guide you how to color alternating between lines to distinguish in Excel 2013. Please refer to.
Step 1:
Open the Excel spreadsheet and then black out the lines to fill, as in the example here I select the rows, column Excel from B2 to H9:
Step 2:
On the menu bar, click the Conditional Formatting item, select New Rule .
Step 3:
When the New Formatting Rule dialog box appears, click the Use a formula line to determine which cells to format and then enter the following formula line in the Format values where this formula field is true: = MOD (ROW (), 2)> 0 . Then click Format .
Step 4:
When the Formatting Rule dialog box appears, click the Fill tab and select the desired color.
Click OK, and we will have the Excel cells colored alternately as shown below:
Step 5:
If you want to change to another color, click on the Conditional Formatting section and select Manage Rules .
Step 6 : When the new dialog appears, click Edit Rule
Step 7 : Click the Format button to change to the desired color
So, you already know how to color between Microsoft Excel lines. This job is small but it will contribute to minimizing errors in the calculation process for you.
- How to convert numbers into words in Excel?
- So what if you want to interleave color data in Excel?
- The most basic functions in Excel
- How to keep the cells fixed in Excel?
Good luck!
You should read it
- Line breaks in Excel
- How to fix the error is not down the line in Excel
- How to color formula cells in Excel automatically
- Coloring alternating excel lines not everyone knows
- How to hide formulas in Excel
- MS Excel - Lesson 5: Excel formulas and functions
- Guidelines for importing Chemistry formulas in Excel
- Guidance on how to align Excel correctly
May be interested
- Add Save and Close options All Documents documents in Wordmicrosoft office word application allows users to open and view multiple documents at the same time. and when you have made all the changes on the open documents then you want to quickly save and close them all at once instead of one by one?
- Instructions for attaching files to PDF files using Foxit Readerare you looking to send some photos and videos to friends in pdf files without knowing what to do? you are looking for ways !!! fortunately, foxit reader supports file attachment, but not everyone knows how to use it! so please refer to the tutorial attached file to pdf file of tipsmake.com below.
- How to quickly see the total number of pages of Word files?you have dozens or even hundreds of word files on your computer and you want to know the total number of pages of each file. however, if opening each file will take a lot of time, so is there a way for you not to open and still know the total number of pages? today, tipsmake.com will guide you how to quickly see the total number of pages of word files.
- How to save files automatically in Adobe Reader?you are constantly editing pdf files when suddenly you lose power or your computer naturally restarts! you cry badly because the data has not been saved yet, how to handle it? while most of us have a habit of staying after completing the job. to prevent this bad situation from happening, please refer to how to enable the automatic saving of pdf files in our adobe reader.
- Free note-taking software for Windows 7 and 8today, tipsmake.com will list the best and completely free note software for windows 7 and windows 8. with these software, your work will become easier and more convenient by it is equipped with many functions to manage, edit, organize and quickly access notes that need to be viewed or displayed.
- Office files are corrupted after upgrading to Windows 10, how to fix?after upgrading from windows 7/8 to windows 10, many users encounter the following error: their office 2013 text files cannot be opened. so how to fix this error?