try this as the formula in conditional format - result will be zer
every 5th row

=MOD(ROW(),5)=

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=27806