Re: How to shade every third row?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

> 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 <at>yahoo<dot>com
----


.

Relevant Pages