How to change the fill color of alternate rows in a table
- 藏色散人Original
- 2021-04-13 14:47:0858123browse
How to set the fill color of alternate rows in the table: 1. Open the Excel table and select the cells; 2. Click Conditional Formatting in the toolbar and select New Rule; 3. Click to select and use formulas to determine the cells to be formatted. grid; 4. Enter the formula "=mod(row(),2)"; 5. Click OK.
The operating environment of this article: Windows7 system, Microsoft Office Excel2010, Dell G3 computer.
1. Open the Excel table on the computer and select the cells.
#2. Then click Conditional Formatting in the toolbar and select New Rule.
#3. After entering the new rule, click to select and use formulas to determine the cells to be formatted.
4. Then enter the formula =mod(row(),2), and then set the fill format color.
#5. After clicking OK, the Excel table will automatically fill every other row with color.
[Recommended: "Excel Tutorial"]
The above is the detailed content of How to change the fill color of alternate rows in a table. For more information, please follow other related articles on the PHP Chinese website!