4 Basic Steps to Color Alternating Columns in Microsoft Excel

This article examines Microsoft Excel and explains the main developments, practical implications, and context readers should understand.

Microsoft Excel Overview

See more articles:

• 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:

In the box:

• 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!