4 basic steps to color alternating columns in Microsoft Excel

In the previous article, TipsMake.com showed you some basic steps to color alternate cells, different data streams in Microsoft Excel. But what about the data column? Many of you have asked such a question, please join us in solving this problem.

See more articles:

1. How to color alternate cells and rows in Micosoft Excel

Step 1:

Drag the mouse and select the columns of data to color, as in this example, from C3 to G19:

Step 2:

Select menu Home> Condition Formatting> New Rule:

Step 3:

The New Rule table displays, you select:

1. Dùng một đối thức đến dertermine mà cơ sở dữ liệu để định dạng

In the box:

1. Format values ​​where this formula is true

We enter the formula:

= MOD (COLUMN (), 2)

Then, select Format to fill the color:

Step 4:

The Format Cells table displays, select the Fill section as shown below. Select the color you want to fill into the different columns in the Background Color section, then click the OK button:

And this is our result:

If you want the Excel worksheet columns to return to normal, do the same as above, apply the columns you want to select, then Home> Conditional Formatting> Clear Rule. The above is a simple trick that makes it easier to master Microsoft Excel spreadsheets, avoiding confusion when entering data, and managing information. Good luck!