Change color between different lines in Microsoft Excel

TipsMake.com - Selecting and pouring colors separately for data areas is especially useful when you have a spreadsheet with lots of different statistics. In the following article, we will show you some steps to do this in Microsoft Excel.

First, open Excel and select the data area to fill, or press Ctrl + A to select all:

Change color between different lines in Microsoft Excel Picture 1

Select the Home tab above and Styles> Conditional Formatting:

Change color between different lines in Microsoft Excel Picture 2

Menu with the form of drop - down displayed, you select New Rule:

Change color between different lines in Microsoft Excel Picture 3

The New Formatting Rule window is displayed, click the button at the bottom of the screen with the name: Use a Formula to Determine Which Cells to Format. If the data field is empty, you use the following formula:

= MOD (ROW () / 2.1)> 0

The New Formatting Rule window will look like this:

Change color between different lines in Microsoft Excel Picture 4

Click the Format button, then select the color to use, click OK :

Change color between different lines in Microsoft Excel Picture 5

Color preview - Color Preview displays on the New Formatting Rule window as shown below, click OK :

Change color between different lines in Microsoft Excel Picture 6

And the data on your spreadsheet will be colorized based on the value and applicable rules. Example as shown below:

Change color between different lines in Microsoft Excel Picture 7

If you want to change the color or add or remove the data stream, we just need to select the corresponding cell, then select Conditional Formatting> Manage Rules:

Change color between different lines in Microsoft Excel Picture 8

The Conditional Formatting Rules Manager window appears, click the Edit Rule button :

Change color between different lines in Microsoft Excel Picture 9

We will be returned to the Edit Formatting Screen section , here you can adjust and set the conditions to change at will:

Change color between different lines in Microsoft Excel Picture 10

Good luck!

>>> Video guide for reference: