Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conditional Formatting New Rule with Formulas in Excel
  • Subtotal function in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Remove Duplicates Example in Excel
  • Filter Data Based on Date in Excel

References

  • Basic INDEX MATCH approximate in Excel
  • Extract data with helper column in Excel
  • How to use Excel COLUMN Function
  • Multi-criteria lookup and transpose in Excel
  • Create hyperlink with VLOOKUP in Excel

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation date in specific year
  • Excel Data validation exists in list
  • Excel Data validation specific characters only
  • Excel Data validation allow uppercase only

Highlight every other row in Excel

by

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 other row in the range B3:F102 select the entire range then create a conditional formatting rule that uses this formula:

=ISEVEN(ROW())

How this formula works

When you use a formula to apply conditional formatting, the formula is evaluated for every cell in the selection. In this case, there are no addresses in the formula, so, for every cell in the data, the ROW and ISEVEN functions are run. ROW returns the row number of the cell, and ISEVEN returns TRUE if the row number is even and FALSE if the row number is odd. The rule will trigger on TRUE, so even rows will be shaded.

To shade odd rows, just use ISODD instead:

=ISODD(ROW())

A MOD alternative

If you’re using an older version of Excel (before 2007) you may not have access to ISEVEN and ISODD. In that case, you can use the “classic” formula for shading even or odd rows, which depends on the MOD function:

=MOD(ROW(),2) = 0 // returns true for even rows
=MOD(ROW(),2) = 1 // returns true for odd rows

MOD takes a number and a divisor as arguments, and returns the remainder. The ROW function provides the number, which is divided by 2, so MOD  returns zero when the row is an even number and 1 if not.

Post navigation

Previous Post:

COSH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Data validation require unique number

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • Extract multiple matches into separate rows in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Add decimal hours to time in Excel
  • Get work hours between dates and times in Excel
  • Convert date to month and year in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into unequal buckets in Excel
  • Group numbers at uneven intervals in Excel

General

  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to calculate percentage discount in Excel
  • Advanced Number Formats in Excel
  • 44 Practical Excel IF function Examples
  • How to calculate percent variance in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning