Hi,

Am Wed, 8 Jan 2014 07:21:28 -0800 (PST) schrieb :

=AND(G8,(MOD(ROW(),2)=1))
=AND(G8,(MOD(ROW(),2)=0))
=AND(NOT(G8),(MOD(ROW(),2)=1))
=AND(NOT(G8),(MOD(ROW(),2)=0))

G8 is true or false.

if the reference always is G8 you have to set it absolute:
=AND($G$8,(MOD(ROW(),2)=1))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2