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:

4 basic steps to color alternating lines in Microsoft Excel Picture 1

Step 2:

On the menu bar, click the Conditional Formatting item, select New Rule .

4 basic steps to color alternating lines in Microsoft Excel Picture 2

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 .

4 basic steps to color alternating lines in Microsoft Excel Picture 3

Step 4:

When the Formatting Rule dialog box appears, click the Fill tab and select the desired color.

4 basic steps to color alternating lines in Microsoft Excel Picture 4

Click OK, and we will have the Excel cells colored alternately as shown below:

4 basic steps to color alternating lines in Microsoft Excel Picture 5

Step 5:

If you want to change to another color, click on the Conditional Formatting section and select Manage Rules .

4 basic steps to color alternating lines in Microsoft Excel Picture 6

Step 6 : When the new dialog appears, click Edit Rule

4 basic steps to color alternating lines in Microsoft Excel Picture 7

Step 7 : Click the Format button to change to the desired color

4 basic steps to color alternating lines in Microsoft Excel Picture 8

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.

  1. How to convert numbers into words in Excel?
  2. So what if you want to interleave color data in Excel?
  3. The most basic functions in Excel
  4. How to keep the cells fixed in Excel?

Good luck!

4 ★ | 1 Vote

May be interested

  • Add Save and Close options All Documents documents in WordPhoto of Add Save and Close options All Documents documents in Word
    microsoft 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 ReaderPhoto of Instructions for attaching files to PDF files using Foxit Reader
    are 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?Photo of 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?Photo of 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 8Photo of Free note-taking software for Windows 7 and 8
    today, 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?Photo of 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?