How can I efficiently shade every other line on a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
Chris,
These formulas, placed in conditional formatting works
great. highlight your intended cells and go to Format >
Conditional Formatting. there are two different ones, the
first does every other row and the second does every
three rows.
=MOD(ROW(),2)=0
=MOD(ROW()-1,6)<=2

HTH
Kevin M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shading 3
Highlight every other line 2
Suppress printing of row shading 1
Shaded for every other row 2
Automatically Copy formatting (I.E. shading) 2
alternate row shading on filtered data 2
Auto-Format Cell Shading 2
when I shade my columns I lose my grid lines 2

Back
Top