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

Data Analysis

  • How to Create Area Chart in Excel
  • How to Create Gantt Chart in Excel
  • How to do a t-Test in Excel?
  • Error Bars in Excel
  • How To Compare Two Lists in Excel

References

  • Offset in Excel
  • Two-way lookup with VLOOKUP in Excel
  • How to get last column number in range in Excel
  • Find closest match in Excel
  • Excel Advanced Lookup using Index and Match Functions

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation specific characters only
  • Excel Data validation must not contain
  • How To Create Drop-down List in Excel
  • Excel Data validation number multiple 100

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

  • How to use Excel OR Function
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Return blank if in Excel
  • OR function Examples in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Display Date is workday in Excel
  • Add years to date in Excel
  • Generate series of dates by weekends in Excel
  • How to calculate project start date based on end date in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • Categorize text with keywords in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • Group arbitrary text values in Excel

General

  • Creating and Opening an existing file in Excel
  • Subtotal by color in Excel
  • How to increase by percentage in Excel
  • Currency vs Accounting Format in Excel
  • Count cells less than in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning