On 23 Sep 2006, ?B?TWF4?= wrote:

Select the entire sheet (with A1 active)
Then click Format Conditional Formatting
For Condition 1,
Formula is: =MOD(ROW(),7)=0
Format: light green fill OK out
The above will shade rows 7, 14, 21, etc


Thank you. As I said to Dave in another part of the thread ... the next
thig to add are the times of sunrise & sunset plus the moon's phases.

Then I will be in heaven. Heh!