4 basic steps to color alternating columns in Microsoft Excel
In the previous article, TipsMake.com showed you some basic steps to color alternate cells, different data streams in Microsoft Excel. But what about the data column?
In the previous article, TipsMake.com showed you some basic steps to color alternate cells, different data streams in Microsoft Excel. But what about the data column? Many of you have asked such a question, please join us in solving this problem.
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:
- Dùng một đối thức đến dertermine mà cơ sở dữ liệu để định dạng
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!
You should read it
- The way to color alternating columns in Excel is extremely simple
- MS Excel - Lesson 4: Working with lines, columns, sheets
- 4 basic steps to color alternating lines in Microsoft Excel
- Steps to lock columns in Excel
- 2 ways to separate column Full and Name in Excel
- How to number columns automatically in Excel
- How to delete, add columns in Excel
- How to keep Excel and Excel columns fixed?
- Instructions for separating column content in Excel
- Coloring alternating excel lines not everyone knows
- Ways to hide data on Excel
- Video tutorial using Freeze feature - fixed column, line in Excel
Maybe you are interested
Create Autotext in Word 2007, edit documents faster Alignment in Word 2010, beautiful alignment of Word 2010 documents How to master numerical data in Google Sheets with the AVERAGE function How to Justify Text in Cells on Excel - Adjust Text Spacing How to create Progress Bar in Excel, conditional progress bar How to strikethrough text in Word, write strikethrough text in Word and Excel