How to apply Color in alternate Rows or Columns in Excel

If you’d like to apply shade in alternate rows and columns in an Excel spreadsheet, here’s what you want to do. It’s attainable to present the specified shade in each alternate row or column with the Conditional Formatting. This performance is included in Microsoft Excel, and you may make use of it with the assistance of this tutorial.

Let’s assume that you’re making a spreadsheet on your faculty or workplace undertaking, and you’ve got to colorize each alternate row or column. There are two methods to try this in Microsoft Excel. First, you’ll be able to choose specific rows or columns and alter the background shade manually. Second, you should use the Conditional Formatting performance to apply the identical in automation. Both means, the end result would be the identical, however the second methodology is extra environment friendly and time saving for any consumer.

How to alternate row colours in Excel

To apply shade in alternate rows or columns in Excel, comply with these steps-

1. Open the spreadsheet with Excel.
2. Choose the rows and columns that you really want to colorize.
3. Click on the Conditional Formatting in the Dwelling tab.
4. Choose New Rule from the record.
5. Choose Use a components to decide which cells to format.
6. Enter =MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0 in the Format values field.
7. Click on the Format button.
8. Swap to the Fill tab.
9. Choose a shade that you really want to use.
10. Click on the OK button twice.

Let’s take a look at these steps in element.

At first, open the spreadsheet with Excel. In case, you would not have the spreadsheet, create it first with the intention to perceive whether or not you need to colorize the rows or columns. As soon as achieved, use your mouse to choose all of the cells (rows and columns). In the event you’re going to apply the colour scheme to your entire spreadsheet, click on the arrow icon that permits you to choose the spreadsheet from high to backside.

Now just be sure you are in the Dwelling tab. In that case, click on on the Conditional Formatting in the Types part, and choose the New Rule choice from the record.

Following that, choose the Use a components to decide which cells to format choice, and write down certainly one of these in the Format values box-

• =MOD(ROW(),2)=0
• =MOD(COLUMN(),2)=0

The primary one will colorize the specified shade in alternate rows and the second is for columns. After that, click on the Format button.

Now, swap to the Fill tab, choose a shade that you really want to use, and click on on the OK button.

Then, you should have to click on the OK button once more to apply the change.

How to apply shading to alternate rows and columns in Excel?

In order to apply shading to alternative rows and columns in Excel, you need to use Conditional Formatting. It is required to use this function: =MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0. Then, you can switch to the Format menu and Fill tab to choose the color as per your requirements.

How to set color to alternate rows and columns in Excel?

As said earlier, you need to use a function to set colors to alternative rows and columns. First, you need to open the Conditional Formatting section and set a new rule. Then, select the Use a formula to determine which cells to format and use this formula: =MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0. Next, you can fill the rows and columns with your desired color.

That’s all! Now you’ll be able to see the chosen shade in each alternate row or column.