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. ISEVEN formula explanation If number…
Tag: ISEVEN function
Shade alternating groups of n rows in Excel
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 shown, the formula used to…
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…