Play with this ..

Select the entire sheet (A1 active)
Click Format Conditional Formatting
Condition 1, Formula Is: =MOD(ROW(),5)=0
Click Format button Patterns tab Green? OK
Click OK at the main dialog

Every 5th line in the sheet will be filled green

If the above appearance is what you're after, just re-do
with "5" changed to "200" in the cond format formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nastech" wrote:

looking for format formula to set a cond. format for hiliting every 200
lines. thanks.