Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: ISODD function

Highlight every other row in Excel

This tutorial shows how to Highlight every other row in Excel using the example below; Formula =ISEVEN(ROW()) Explanation If you want to highlight every other row in a table (sometimes called zebra striping) with conditional formatting you can do so with a simple formula that uses either the ISEVEN or ISODD function. For example, if you want to highlight every…