Conditional formatting basics in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply conditional formatting that highlights cells greater than 100.

Google Sheets

Format cells if: Cell value [1] 100

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

Ais not equal to

Bis less than

Cis equal to

Dis greater than

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'is less than' will highlight smaller numbers, not bigger ones.

Using 'is equal to' only highlights cells exactly 100.

The rule should highlight cells with values greater than 100, so use 'is greater than'.

2fill in blank

medium

Complete the formula to highlight cells in column A that contain the word "Done".

Google Sheets

Custom formula is: =ISNUMBER([1](A1, "Done"))

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

AISNUMBER

BSEARCH

CLEN

DSUM

Attempts:

3 left

💡 Hint

Common Mistakes

Using ISNUMBER alone won't find text, it checks if a value is a number.

LEN counts characters, not search for text.

The SEARCH function looks for text inside a cell. It returns a number if found, so it works for this condition.

3fill in blank

hard

Fix the error in the formula to highlight cells in B2:B10 that are empty.

Google Sheets

=ISBLANK([1])

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

AB2

BB2:B

CB$2:B$10

DB2:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a range like B2:B10 inside ISBLANK causes errors.

Using absolute references ($) is not needed here.

Conditional formatting formulas apply to each cell individually. Use a single cell reference like B2, not a range.

4fill in blank

hard

Fill both blanks to create a formula that highlights cells in C2:C20 if the value is between 50 and 100.

Google Sheets

=AND(C2 [1] 50, C2 [2] 100)

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

A>=

B<=

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using > or < excludes the boundary values.

Mixing up the order of operators causes wrong results.

The formula checks if C2 is greater than or equal to 50 and less than or equal to 100.

5fill in blank

hard

Fill all three blanks to create a formula that highlights cells in D2:D15 if the text starts with "Urgent".

Google Sheets

=LEFT([1], [2]) = [3]

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

AD2

B6

C"Urgent"

D7

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong cell reference.

Using the wrong number of characters in LEFT.

Not putting the text in quotes.

The LEFT function extracts the first 6 characters from D2 and compares them to the text "Urgent".