Conditional Formatting:

[James Perry]

If i want to colour-format EVEN rows the Formula is:
MOD(Row(),2 = 0
To CF every 3rd row the Formula is:
MOD(Row(),3 = 0
To CF every 5th row its:
MOD(Row(),5 = 0
So, based on the above; its the 'divisor-number' that decides which row gets coloured if the equation is set to zero & with Excel evaluating a True or False condition.
It works!!! But can some1 can please enlighten further.
Thank U.

 

[Somendra Misra]

@James Perry

What enlightenment do you exactly want? On the MOD formula or something else?

Somendra.

 

[kchiba]

MOD is the remainder after you divide two numbers, Row(), is the number of the row that the formula is in

So if you are in row 2 and the Formula is MOD(ROW(),2) = 0 you are calculating 2/2 = 1 remainder 0 TRUE
if you are in Row 3 you are calculating 3/2 = 1 remainder 1 so it is False.

Hope this helps, I suggest you read the Help for MOD and Row

 

[James Perry]

@kchiba: Perfect. Thank u.