×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Microsoft: Office FAQ

Best of Excel

 How can I shade alternate rows automatically? by KenWright faq68-4744 Posted: 20 Jan 04 Use a conditional format to do this and it will not move when you sort the rows:-Do CTRL+A, then Format / Conditional Formatting / Change 'cell value is' to 'formula is' and putin =MOD(ROW(),2)=1Now click on the format button and choose a nice pastel colour from the patterns tab.  Hit OK tillyou are out and you are done.You could also put in=MOD(ROW(),2)=0 if you wanted the other rows to be coloured.You could also put in=MOD(ROW(),3)=0 if you wanted every 3rd row to be coloured.You could also put in=MOD(ROW(),4)=0 if you wanted every 4th row to be coloured.You could also put in=MOD(ROW(),5)=0 if you wanted every 5th row to be coloured.But you probably get the drift by now.  Flipping the 1 and the 0 will determine whether or not youstart with a coloured or a non-coloured row.If you want to create alternate green bars made up of say 3 rows (or any other color), you canalso use:For every three rows:=MOD(ROW()-1,6)<3For every four rows:=MOD(ROW()-1,8)<4For other number of shadings, just make the 2nd number (6 or 8 in example) twice as much as the3rd number (3 or 4 in example) Back to Microsoft: Office FAQ Index Back to Microsoft: Office Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!