cond. format for hilite every 200 lines

N

nastech

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

nastech

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

Max

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
 
B

B. R.Ramachandran

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
 
Top