Excel gives a "wrong formula" error when there OBVIOUSLY isnt one. I copied the formula straight from Microsoft's website

Question

I want to shade alternating rows, so I searched for a formula and found one on Microsoft's site. It's this:

=MOD(ROW(),2)=0

And I've seen it being used in many other tutorials for the same thing too, but my Excel says there's something wrong with it. What is the problem?

Answer 1

If semicolons work for you, you may also need to adapt the function names (mod, row) to their localized versions.