cond. format for hilite every 200 lines

cond. format for hilite every 200 lines

Post by bmFzdGVja » Sat, 04 Feb 2006 20:23:46


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

cond. format for hilite every 200 lines

Post by bmFzdGVja » Sat, 04 Feb 2006 20:30:11

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

 
 
 

cond. format for hilite every 200 lines

Post by TWF4 » Sat, 04 Feb 2006 20:36:38

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
 
 
 

cond. format for hilite every 200 lines

Post by Qi4gUi5SYW » Sat, 04 Feb 2006 20:43:43

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