Thank you so much! It works beautifully! ;-)

"Max" wrote:

Formula is: =MOD(ROW(),3)=0

On separate sheets, try also tinkering with the other 2 possible settings
for the formula in condition1, viz., try instead:

=MOD(ROW(),3)=1
=MOD(ROW(),3)=2

to see the differences that changing the formula makes to the row shading

(Btw, I'm also using Jim's add-in .. )

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----