I guess that you intended to say =MOD(ROW(),2) ?
--
David Biddulph

"willem" wrote in message
...
Found Solution with conditional formatting for either rows or columns
=MOD(ROW()2)

automatically updates format either when inserting or deleting rows
columns
etc

W