I'm trying to set up alternating row styling on a selection. I click on the first row and drag down to row 145 (where data ends).

Then I go into Conditional Formatting, choose new rule, and am trying to enter this formula:

```
=MOD(ROW(),2)=0
```

When I click OK, I get this not very helpful error in Excel 2016:

```
There's a problem with this formula.
Not trying to type a formula? When the first character is
an equal (=) or minus (-) sign, Excel thinks it's a formula.
<snip>
```

What is wrong with the formula?

## Best Answer

Try to use ";" instead of "," before number.

Background:Some locales use a"List separator"character that is not the comma character. If you are outside the US, this might be the case for you.Details here:http://datapigtechnologies.com/blog/index.php/why-your-version-of-excel-only-accept-semicolons-in-formulas-instead-of-commas/