Buzz
Unlike Word, Excel is divided into multiple cells with separate rows and columns, making calculations easier and more convenient. However, when we have to compose text with Excel, it can be very confusing and inconvenient to follow if you don't know how to apply alternating colors between them.
Applying Alternating Colors in Excel Spreadsheets
Applying Alternating Colors in Excel Spreadsheets enhances the visual appeal of our documents, making them easier to read and preventing confusion between rows in a densely packed table. Imagine an Excel spreadsheet with only monotone rows or columns; it would make it difficult to distinguish between data. While you can manually color the background of columns and rows in a spreadsheet, this process would consume a lot of your time. However, fret not, because with Microsoft Excel, you can automate this task using a highly useful tool called Conditional Formatting. That's why in the following article, we will provide detailed guidance on how to use Conditional Formatting to apply alternating colors in Excel spreadsheets.
Guide to Applying Alternating Colors in Excel
1. How to Apply Alternating Colors in Excel 2016
The following guide will show you how to apply alternating colors in Excel 2016. However, the process for applying alternating colors remains largely the same across different Excel versions, so you can apply it to earlier versions such as Excel 2013, 2010, and 2007. To apply alternating colors in Excel 2016, we'll use a simple example. Suppose we have a list of employee performance evaluations. Now, let's apply alternating colors in Excel 2016 to these list cells.
Step 1: To apply alternating colors in Excel 2016, select the cells you want to color alternately. Although this step may seem simple, starting off with this approach can simplify the process.
Step 2: Next, on the Home tab of Excel, choose Conditional Formatting > select New Rule...
Step 3: Then, select the last option, Use a formula to determine which cells to format, below which we enter =MOD(ROW(),2)>0 and then click on Format.
Step 4: Next, choose Fill and select the color you want to use to apply alternating colors in Excel 2016.
Afterward, simply press OK and the result will appear as shown below.
Step 5: You can apply the alternating color method in Excel 2016 to other cells by selecting the Rule we just created, then simply click on Manage Rules.
Step 6: Here you will see a list of the Rules we just created, and you only need to click to change the color.
Step 7: Continue applying steps 3 and 4 to change the color and select the color you desire.
2. How to Apply Alternating Colors in Excel 2013 Spreadsheets
Step 1: Open the Excel spreadsheet where you want to apply alternating colors.
Step 2: Apply alternating colors to the rows on the spreadsheet using Conditional Formatting.
On the program interface, go to the Home tab of the Ribbon, choose Conditional Formatting in the Style group, then select New Rule from the dropdown menu.
A New Formatting Rule dialog box will appear. In the Format values where this formula is true box, enter the following formula: =MOD(ROW(),2)>0
Next, to select the fill color for alternating rows, click the Format button, the Format Cells dialog box appears, click on the Fill tab, and choose the color you want to fill (here I choose light blue). Finally, click OK to finish.
Step 3: Change the fill color on alternating rows.
If you want to choose a different color (other than the blue color above), select Conditional Formatting and then click on Manage Rule.
The Conditional Formatting Rule Manager dialog box appears, select the Edit Rule item.
Click on the Format cell and proceed to choose the color you want to change to (here Mytour selects yellow). Then click OK to finish.
The result has changed:
So, through the above instructions, you can clearly see that applying alternating colors between rows and columns in Excel helps you have a visual perspective, making it easy to track data in Excel spreadsheets flexibly and minimize errors when working with large amounts of data. Additionally, if you need to add or remove rows or columns in Excel to serve your tasks, the process is quite simple. However, if you encounter difficulties, especially if you are a recent graduate lacking experience, the article on adding or removing rows or columns in Excel spreadsheets shared earlier should help satisfy your needs for a more complete workflow.
Along with that, if you, as a reader, have the need to count words in Excel for calculation or to combine with other functions, or for any purpose, there is no single formula used to count words, only the LEN function is used to count characters including spaces between words. We can see that every 2 words will have one space, so instead of counting the number of words, we count the number of spaces in the string of words and add one to get the number of words by combining this LEN function with the SUBSTITUTE and TRIM functions. Thus, it will be quite simple if you readers refer to the article on how to count words in Excel, in cells, rows, columns shared earlier by us. If you encounter difficulties during implementation, do not hesitate to comment below, the technical team of Mytour will support you.
