SpookiePower skrev:

I found the error.

In all the examples I have found they use a "," before 2 -
=MOD(ROW(),2)

It works when I use ";" insted -
=MOD(ROW();2)

But why do the examples use ","

http://www.xldynamic.com/source/xld.CF.html#top
http://www.ozgrid.com/Excel/alternate-row-color.htm

Using "," or ";" is dependent on localization IIRC, thus an 'english
Excel install' uses "," but a 'swedish Excel install' uses ";". Erm, or
vice versa :)

/impslayer, aka Birger Johansson