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 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 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 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 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 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 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 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 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.