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

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

"Max" wrote:

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.

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.

Hi,

Highlight the entire page -- "Format" -- "Conditional Format" --
Formula Is (use one of the following formulas) -- format for cell shading
-- "OK".

For shading rows 200, 400, 600, ... =MOD(ROW(),200)=0
For shading rows 1, 201, 401, 601, ... =MOD(ROW(),200)=1
For shading rows 2, 202, 402, 602, .... =MOD(ROW(),200)=2
etc., etc.

Regards,
B. R. Ramachandran


"nastech" wrote:

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