Conditional Formatting

Condition1: For odd rows
=MOD(ROW(),2)=1

Condition2: For even rows
=MOD(ROW(),2)=0

Format any color you like



"STS" wrote:

Hi,

How can I shade multiple rows at the same time, for example all odd row
numbers in gray, all even numbers in blue? I am sure there is a better way of
doing it than manualy row by row. Thank you for your help.