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

Data Analysis

  • How To Load Analysis ToolPak in Excel
  • How to calculate current stock or inventory in Excel
  • Chart Axes in Excel
  • How to Create Column Chart in Excel
  • Conditional Formatting Data bars Examples in Excel

References

  • Left Lookup in Excel
  • Vlookup Examples in Excel
  • Count rows that contain specific values in Excel
  • How to use Excel ROWS Function
  • Offset in Excel

Data Validations

  • Excel Data validation specific characters only
  • How To Create Drop-down List in Excel
  • Data validation must not exist in list
  • Excel Data validation unique values only
  • Excel Data validation date in next 30 days

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
  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • FALSE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • List holidays between two dates in Excel
  • Convert date to text in Excel
  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Get project midpoint in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel
  • Map text to numbers in Excel
  • If cell contains one of many things in Excel

General

  • Creating and Opening an existing file in Excel
  • 44 Practical Excel IF function Examples
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • Check if range contains a value not in another range in Excel
  • How to set or clear a print area in Excel Worksheet
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning