 |
 | 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 / November 2006Coloured rows
Usaing excel 2000, how do I get alternate coloured rows without having to select and colour each one?? Tim Select all the rows you want coloured. Use Format | Conditional Formatting Use Formula is: and enter =MOD(ROW(),2)=1 and then set a pattern (colour for the alternate rows) best wishes  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Usaing excel 2000, how do I get alternate coloured rows without having to > select and colour each one?? > > Tim I've used the formula: =MOD(ROW(),2)=0 I'm not very well versed in Excel formulas so forgive my ignorance. What the difference between =0 and =1? SignatureJoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 > Select all the rows you want coloured. > Use Format | Conditional Formatting [quoted text clipped - 6 lines] >> >> Tim Hi JoAnn, The MOD function as used here gives the remainder of a division by 2 so will alternate per row between 0 and 1. It doesn't matter if you test for 0 or for 1, that just determines which color the first row has. SignatureKind regards, Niek Otten Microsoft MVP - Excel | I've used the formula: | =MOD(ROW(),2)=0 [quoted text clipped - 12 lines] | >> | >> Tim Aha............thank you. :-) SignatureJoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 > Hi JoAnn, > [quoted text clipped - 21 lines] > | >> > | >> Tim > Aha............thank you. :-) It so simple when you know how!! Thanks guys Tim Most things are. SignatureJoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 >> Aha............thank you. :-) > [quoted text clipped - 3 lines] > > Tim For future reference http://www.datapigtechnologies.com/flashfiles/alternateshading.html You can also highlight every 5 rows or whatever number by changing the formula. Epinn Usaing excel 2000, how do I get alternate coloured rows without having to select and colour each one?? Tim or http://xldynamic.com/source/xld.CF.html#rows -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) For future reference http://www.datapigtechnologies.com/flashfiles/alternateshading.html You can also highlight every 5 rows or whatever number by changing the formula. Epinn Usaing excel 2000, how do I get alternate coloured rows without having to select and colour each one?? Tim I didn't know you had a paper on conditional format. The traffic lights look like fun. More reading for me. Thanks. or http://xldynamic.com/source/xld.CF.html#rows -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) For future reference http://www.datapigtechnologies.com/flashfiles/alternateshading.html You can also highlight every 5 rows or whatever number by changing the formula. Epinn Usaing excel 2000, how do I get alternate coloured rows without having to select and colour each one?? Tim
|
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.