Managing rule priority in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to apply conditional formatting only if the cell value is greater than 100.

Google Sheets

=IF(A1 [1] 100, TRUE, FALSE)

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

A<

B>

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' will check for smaller values.

Using '=' will only check for exactly 100.

The formula checks if the value in cell A1 is greater than 100 to apply the formatting.

2fill in blank

medium

Complete the formula to prioritize formatting when the cell value is exactly 50.

Google Sheets

=IF(A1 [1] 50, TRUE, FALSE)

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

A=

B>=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' or '<' will not check for exact equality.

The formula checks if the value in A1 is exactly 50 to decide the formatting.

3fill in blank

hard

Fix the error in the formula to correctly apply formatting when the value is less than or equal to 20.

Google Sheets

=IF(A1 [1] 20, TRUE, FALSE)

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

A<=

B=>

C<

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=>' instead of '<=' causes errors.

Using '==' is not valid in Google Sheets formulas.

The correct operator for 'less than or equal to' is '<=' in Google Sheets formulas.

4fill in blank

hard

Fill both blanks to create a formula that applies formatting only if the value is between 10 and 30 inclusive.

Google Sheets

=AND(A1 [1] 10, A1 [2] 30)

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '<=' excludes 30.

Using '>' instead of '>=' excludes 10.

The formula uses '>= 10' and '<= 30' to check if A1 is between 10 and 30, including both ends.

5fill in blank

hard

Fill all three blanks to create a formula that applies formatting if the value is greater than 0, less than 100, and not equal to 50.

Google Sheets

=AND(A1 [1] 0, A1 [2] 100, A1 [3] 50)

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

A>

B<

C<>

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' instead of '<>' will check for equality, not inequality.

Mixing up '<' and '>' operators.

The formula checks that A1 is greater than 0, less than 100, and not equal to 50 using the operators '>', '<', and '<>' respectively.