The Way to Color Alternating Columns in Excel Is Extremely

Step 1: Basic Steps for Coloring Alternating Columns in Excel

Drag and select the data columns to be colored, as in this example are from C3 to G16:

Step 2:

Select the Home menu> Condition Formatting> New Rule:

Step 3:

The New Rule table displays, select:

Use a Formula to dertermine which cells to format

At the box:

Format values where this formula is true

We enter the formula:

= MOD (COLUMN (), 2)

Then choose Format to fill:

Step 4: Basic Steps for Coloring Alternating Columns in Excel

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

And here is our result:

If you want the columns in the Excel worksheet to return to normal then you do the same as above, highlight the columns to select and then Home> Conditional Formatting> Clear Rule. The above is a simple trick to help us master Microsoft Excel spreadsheets more easily, avoid confusion when entering data, managing information.