|
|
|
|
|
Fill every other row with color
We're going to learn how to fill every second row of your sheet with color using conditional formatting in Excel.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Open a document you want to apply conditional formatting in.
|
|
| |
3.
|
|
|
Click the Conditional Formatting button ...
|
|
| |
4.
|
|
|
... and choose New Rule...
|
|
| |
5.
|
|
|
In the New Formatting Rule window select Use a formula to determine which cells to format.
|
|
| |
6.
|
|
|
Enter =mode(row();2) into Format values where this formula is true field.
|
|
| |
8.
|
|
|
Click the Font tab and choose font Color.
|
|
| |
9.
|
|
|
Select the Fill tab and choose cell color
Click OK.
|
|
| |
11.
|
|
|
Your Excel sheet should now have every other line filled with color of your choice.
|
|
|
 |
|
|
|
|
