 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007how to shade every other 5 rows
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. > 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.... > Click on the Row-Header (the actual 1 in the left margin) - then Format, > Conditional Formatting, Select Formula Is drop-down in box enter: [quoted text clipped - 10 lines] > > > 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 > now is there a formuala for it to shade 5 rows and then skip 5 rows and so > on.... [quoted text clipped - 13 lines] > > > > > how to shade every other 5 rows Thanks the formula works great ! > Try something like this: > [quoted text clipped - 32 lines] > > > > > > > how to shade every other 5 rows > > > 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 Fri, 27 Apr 2007 11:02:06 -0700 from chiechka <chiechka@discussions.microsoft.com>: > 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.  SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ The formula it works great and thanks for the explaination. > > > > how to shade every other 5 rows > [quoted text clipped - 19 lines] > Testing for <5 gives you the first 5 rows, skips the next 5, hits the > next 5, and so on. > 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
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.