## Explanation

When you use a formula to apply conditional formatting, the formula is evaluated for every cell in the selection. In this case, there are no addresses in the formula, so, for every cell in the data, the ROW and ISEVEN functions are run. ROW returns the row number of the cell, and ISEVEN returns TRUE if the row number is even and FALSE if the row number is odd. The rule will trigger on TRUE, so even rows will be shaded.

To shade odd rows, just use ISODD instead:

```
=ISODD(ROW())
```

### A MOD alternative

If you're using an older version of Excel (before 2007) you may not have access to ISEVEN and ISODD. In that case, you can use the "classic" formula for shading even or odd rows, which depends on the MOD function:

```
=MOD(ROW(),2) = 0 // returns true for even rows
=MOD(ROW(),2) = 1 // returns true for odd rows
```

MOD takes a number and a divisor as arguments, and returns the remainder. The ROW function provides the number, which is divided by 2, so MOD returns zero when the row is an even number and 1 if not.