如果您想申请在交替的行和列颜色在Excel spreadsheet,这里是你需要做什么。它可以显示与Conditional Formatting每alternate row or column所需的颜色。此功能包含在Microsoft Excel,你可以利用它与本教程的帮助
让我们假设你是一个电子表格为您school or office project,你有上色每alternate row or column。有两种方法可以做到,在Microsoft Excel。首先,你可以选择特定的行或列,并手动更改background color。其次,你可以使用条件格式功能,适用相同的自动化。无论哪种方式,其结果将是相同的,但第二种方法是更有效的和节省时间的任何用户
如何Excel交替行的颜色
为了在交替行或列应用颜色Excel,请按照下列步骤 -
- 与Excel打开电子表格。
- 选择您要上色的行和列。
- Click的Conditional Formatting在Home tab。
- Select New Rule从列表中。
- Select Use一个公式来确定哪些细胞格式。
- Enter =MOD(ROW(),2)=0 or =MOD在Format值(COLUMN(),2)= 0框。
- Click的Format button。
- 切换到Fill tab。
- 选择您要使用的颜色。
- Click的OK button两次
让我们详细看看这些步骤
首先,打开电子表格与Excel。在情况下,你没有电子表格,首先创建它,这样你可以了解你是否要上色的行或列。一旦完成,用鼠标选中所有单元格(行和列)。如果你打算到color scheme应用到整个电子表格,单击arrow icon,使您可以选择电子表格从上到下
现在,请确保您的主页选项卡。如果是这样,请单击在样式部分Conditional Formatting,并从列表中选择新的规则选项
此后,选择一个Use公式来确定哪些小区格式选项,并记下在Format值其中之一箱 -
- = MOD(ROW(),2)= 0
- = MOD(COLUMN(),2)= 0
第一个将上色所需的颜色在交替的行,而第二个是用于列。在那之后,单击格式按钮
现在,切换到填充选项卡,选择一种颜色,你要使用,并单击OK按钮
然后,你将不得不再次单击OK按钮应用更改
就这样!现在你可以看到在每一个alternate row or column所选择的颜色
.
How to apply Color in alternate Rows or Columns in Excel
If you wаnt to apply color in аlternate rows and columns in an Excel sрrеadsheet, herе is what you need to do. It is possible to show the desirеd color in eνery alternate row or column with the Conditional Formatting. This functionality is included in Microsoft Excel, and you can make use of it with the help of this tutorial.
Let’s assume that you are making a spreadsheet for your school or office project, and you have to colorize every alternate row or column. There are two ways to do that in Microsoft Excel. First, you can select particular rows or columns and change the background color manually. Second, you can use the Conditional Formatting functionality to apply the same in automation. Either way, the result will be the same, but the second method is more efficient and time saving for any user.
How to alternate row colors in Excel
To apply color in alternate rows or columns in Excel, follow these steps-
- Open the spreadsheet with Excel.
- Select the rows and columns that you want to colorize.
- Click the Conditional Formatting in the Home tab.
- Select New Rule from the list.
- Select Use a formula to determine which cells to format.
- Enter
=MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0
in the Format values box. - Click the Format button.
- Switch to the Fill tab.
- Select a color that you want to use.
- Click the OK button twice.
Let’s check out these steps in detail.
At first, open the spreadsheet with Excel. In case, you do not have the spreadsheet, create it first so that you can understand whether you want to colorize the rows or columns. Once done, use your mouse to select all the cells (rows and columns). If you’re going to apply the color scheme to the entire spreadsheet, click the arrow icon that allows you to select the spreadsheet from top to bottom.
Now make sure that you are in the Home tab. If so, click on the Conditional Formatting in the Styles section, and select the New Rule option from the list.
Following that, select the Use a formula to determine which cells to format option, and write down one of these in the Format values box-
- =MOD(ROW(),2)=0
- =MOD(COLUMN(),2)=0
The first one will colorize the desired color in alternate rows and the second one is for columns. After that, click the Format button.
Now, switch to the Fill tab, select a color that you want to use, and click on the OK button.
Then, you will have to click the OK button again to apply the change.
That’s all! Now you can see the selected color in every alternate row or column.