cond. format for hilite every 200 lines
 

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

cond. format for hilite every 200 lines
 

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.

cond. format for hilite every 200 lines
 

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.

cond. format for hilite every 200 lines
 

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.