How to change the fill color of alternate rows in a table

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!