Alternating row colors in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to color every other row starting from the first row.

Google Sheets

=ISEVEN([1]())

Drag options to blanks, or click blank then click option'

AROW

BCELL

CCOLUMN

DINDEX

Attempts:

3 left

💡 Hint

Common Mistakes

Using COLUMN() instead of ROW()

Using CELL() which needs extra parameters

Using INDEX() which is for retrieving values

The ROW() function returns the row number of the current cell. Using ISEVEN(ROW()) colors even rows.

2fill in blank

medium

Complete the formula to color odd rows instead of even rows.

Google Sheets

=IS[1](ROW())

Drag options to blanks, or click blank then click option'

AEVEN

BMOD

CODD

DISNUMBER

Attempts:

3 left

💡 Hint

Common Mistakes

Using ISNUMBER which just checks if a value is a number

Using MOD without proper parameters

Using EVEN which checks for even numbers

Using ISODD(ROW()) returns TRUE for odd rows, so you can color odd rows.

3fill in blank

hard

Fix the error in the formula to color every third row starting from the first row.

Google Sheets

=MOD(ROW(), [1]) = 0

Drag options to blanks, or click blank then click option'

A0

B2

C1

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using 2 colors every second row instead of every third

Using 1 which colors every row

Using 0 which causes an error

The MOD(ROW(), 3) = 0 formula returns TRUE for every third row (3, 6, 9, ...).

4fill in blank

hard

Fill both blanks to color rows where the row number is divisible by 4 and the column number is even.

Google Sheets

=AND(MOD(ROW(), [1]) = 0, ISEVEN([2]()))

Drag options to blanks, or click blank then click option'

A4

B3

CCOLUMN

DROW

Attempts:

3 left

💡 Hint

Common Mistakes

Using ROW() instead of COLUMN() for the second blank

Using 3 instead of 4 for the divisor

Mixing up the order of conditions

The formula colors rows divisible by 4 and columns that are even numbers. MOD(ROW(), 4) = 0 checks rows, ISEVEN(COLUMN()) checks columns.

5fill in blank

hard

Fill all three blanks to color rows where the row number is odd, the column number is odd, and the row number is less than 10.

Google Sheets

=AND(IS[1](ROW()), IS[2](COLUMN()), ROW() [3] 10)

Drag options to blanks, or click blank then click option'

AODD

C<

DEVEN

Attempts:

3 left

💡 Hint

Common Mistakes

Using ISEVEN instead of ISODD

Using > instead of < for the row limit

Mixing up row and column functions

This formula colors cells where the row is odd, the column is odd, and the row number is less than 10. It uses ISODD for row and column checks and < for the comparison.