• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


Highlight Alternating Rows With Conditional Formatting

March 25, 2009 by Mark 2 Comments

You can apply conditional formatting to your sheet that will allow you to format every other row however you specify. Select the area where you want to highlight alternating rows. Go to the Format menu and select Conditional Formatting. For Condition 1, select "Formula Is", and type in "=MOD(ROW(),2)=0" if you want to highlight every even row, or type … [Read more...]

Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Categories

  • Macros (34)
  • Tips (67)
  • Uncategorized (23)



Copyright © 2023 · Magazine Pro Theme on Genesis Framework · WordPress · Log in

Login Form

Lost your password?