Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
how to shade every other 5 rows
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
Click on the Row-Header (the actual 1 in the left margin) - then Format,
Conditional Formatting, Select Formula Is drop-down in box enter: =MOD(ROW(),5)=0 Click Format button, select Gray Pattern Ok, out Again Click on Row-Header (only on 1st row) - Select Format-Painter and click on row-header 2 and drag down the row-header column to say 100 That should get you rows 1 - 100. "chiechka" wrote: how to shade every other 5 rows |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
chiechka wrote:
how to shade every other 5 rows Here's a link to a handy little free tool called ASAP Utilities http://www.asap-utilities.com/ It has MANY useful tools. One of them being highlight every nth row. gls858 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
now is there a formuala for it to shade 5 rows and then skip 5 rows and so
on.... "JMay" wrote: Click on the Row-Header (the actual 1 in the left margin) - then Format, Conditional Formatting, Select Formula Is drop-down in box enter: =MOD(ROW(),5)=0 Click Format button, select Gray Pattern Ok, out Again Click on Row-Header (only on 1st row) - Select Format-Painter and click on row-header 2 and drag down the row-header column to say 100 That should get you rows 1 - 100. "chiechka" wrote: how to shade every other 5 rows |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
Try something like this:
Select the rows to be impacted, with A1 as the active cell From the Excel main menu: <format<conditional formatting Formula is: =MOD(CEILING(ROW()/5,1),2)=1 Click the [format] button and set the shading pattern Click [OK] Click [OK] (again) Is that something you can work with? Does that help? *********** Regards, Ron XL2002, WinXP "chiechka" wrote: now is there a formuala for it to shade 5 rows and then skip 5 rows and so on.... "JMay" wrote: Click on the Row-Header (the actual 1 in the left margin) - then Format, Conditional Formatting, Select Formula Is drop-down in box enter: =MOD(ROW(),5)=0 Click Format button, select Gray Pattern Ok, out Again Click on Row-Header (only on 1st row) - Select Format-Painter and click on row-header 2 and drag down the row-header column to say 100 That should get you rows 1 - 100. "chiechka" wrote: how to shade every other 5 rows |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
"chiechka" wrote:
how to shade every other 5 rows "JMay" wrote: Click on the Row-Header (the actual 1 in the left margin) - then Format, Conditional Formatting, Select Formula Is drop-down in box enter: =MOD(ROW(),5)=0 Click Format button, select Gray Pattern Fri, 27 Apr 2007 11:02:06 -0700 from chiechka : now is there a formuala for it to shade 5 rows and then skip 5 rows and so on.... Sure. =MOD(ROW()-1,10)<5 "Mod" is the modulus function, the remainder after division. If you divide by 10, you're taking the last digit. So if ROW() begins at 1, then ROW()-1 begins at 0. The result of MOD is 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, etc. Testing for <5 gives you the first 5 rows, skips the next 5, hits the next 5, and so on. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
Thanks the formula works great !
"Ron Coderre" wrote: Try something like this: Select the rows to be impacted, with A1 as the active cell From the Excel main menu: <format<conditional formatting Formula is: =MOD(CEILING(ROW()/5,1),2)=1 Click the [format] button and set the shading pattern Click [OK] Click [OK] (again) Is that something you can work with? Does that help? *********** Regards, Ron XL2002, WinXP "chiechka" wrote: now is there a formuala for it to shade 5 rows and then skip 5 rows and so on.... "JMay" wrote: Click on the Row-Header (the actual 1 in the left margin) - then Format, Conditional Formatting, Select Formula Is drop-down in box enter: =MOD(ROW(),5)=0 Click Format button, select Gray Pattern Ok, out Again Click on Row-Header (only on 1st row) - Select Format-Painter and click on row-header 2 and drag down the row-header column to say 100 That should get you rows 1 - 100. "chiechka" wrote: how to shade every other 5 rows |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shade every other 5 rows
The formula it works great and thanks for the explaination.
"Stan Brown" wrote: "chiechka" wrote: how to shade every other 5 rows "JMay" wrote: Click on the Row-Header (the actual 1 in the left margin) - then Format, Conditional Formatting, Select Formula Is drop-down in box enter: =MOD(ROW(),5)=0 Click Format button, select Gray Pattern Fri, 27 Apr 2007 11:02:06 -0700 from chiechka : now is there a formuala for it to shade 5 rows and then skip 5 rows and so on.... Sure. =MOD(ROW()-1,10)<5 "Mod" is the modulus function, the remainder after division. If you divide by 10, you're taking the last digit. So if ROW() begins at 1, then ROW()-1 begins at 0. The result of MOD is 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, etc. Testing for <5 gives you the first 5 rows, skips the next 5, hits the next 5, and so on. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shade hidden rows | Excel Discussion (Misc queries) | |||
shade alternating rows in excel | Excel Discussion (Misc queries) | |||
shade rows | Excel Discussion (Misc queries) | |||
shade rows | Excel Discussion (Misc queries) | |||
How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) |