cond. format for hilite every 200 lines
 

"nastech" wrote:
hi, thanks formula's work, hate to ask, but ran into question on how to pic a
starting point, say record 100. thanks again

Presume "record 100" is in row 100 ?
Tinker along these lines ..

Select rows 100 to 114 (say),
then apply the CF using the cond format formula:
=MOD(ROW(A1),5)=0

The above will fill every 5th row from the starting row (row 100):
rows 104, 109 & 114
with the colour specified

And if you want rows 100, 105, 110 to be coloured instead,
just change the formula above to: =MOD(ROW(A1),5)=1
(adjust the value after the last "=" sign)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---