"Bob Phillips" wrote in message
...
Gareth,

Using Conditional Formatting.

Select all of your target rows
Go to FormatConditional Formatting
Change Condition1 to Formula Is
Input the formula =MOD(ROW(),5)=0
Click the format button
Select the Pattern tab
Choose a colour (Light Green is good)
Exit out

The beauty of this solution is that it works correctly even if you insert
rows

Hi Bob,

That is marvelous - not just the solution (which I will try in a moment),
but the speed at which you replied.

Thanks and best wishes,

Gareth Edmondson