Please explore Conditional formatting formula

[sachar]

Dear All,

With reference to the attachment applied the condition formula “=mod (row (),2)=0”, may I know the meaning of “0” here?

Thanks.

 

[Hui]

=mod (row (),2)=0
Means if the row number is evenly divided by 2 it will have a remainder of zero
ie: It is an even numbered row

You can also use:
=Iseven(Row())

You may also want to have a read of:
http://chandoo.org/wp/2011/12/08/formula-forensics-no-005/
where it is discussed in more detail

 

[sachar]

Dear Hui,

Thanks for your positive answer in details.