Tag: ISEVEN function

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 …

Continue Reading

Shade alternating groups of n rows in Excel

by

This tutorial shows how to Shade alternating groups of n rows in Excel using the example below; Formula =ISEVEN(CEILING(ROW()-offset,n)/n) Explanation To highlight rows in groups of “n” (i.e. shade every 3 rows, every 5 rows, etc.) you can apply conditional formatting with a formula based on the ROW, CEILING and ISEVEN functions. In the example …

Continue Reading

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

by

What is ISEVEN function in Excel? ISEVEN function is one of the Information functions in Microsoft Excel that returns TRUE if number is even, or FALSE if number is odd. Syntax of ISEVEN function ISEVEN(number) The ISEVEN function syntax has the following arguments: Number: The value to test. If number is not an integer, it is truncated. …

Continue Reading