Color scales in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply a 3-color scale conditional formatting rule in Google Sheets.

Google Sheets

ApplyConditionalFormat(range, {colorScale: {minpoint: {type: 'min'}, midpoint: {type: 'percentile', value: 50}, maxpoint: {type: 'max'}, colors: ['red', [1], 'green']}})

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

Apurple

Bblue

Corange

Dyellow

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a color that does not visually represent a middle value well.

Using a color not supported by Google Sheets color scale.

The middle color in a 3-color scale is often yellow to show mid values between red (low) and green (high).

2fill in blank

medium

Complete the code to set the minimum point type to 'number' with value 0 in a color scale.

Google Sheets

ApplyConditionalFormat(range, {colorScale: {minpoint: {type: [1], value: 0}, midpoint: {type: 'percentile', value: 50}, maxpoint: {type: 'max'}, colors: ['red', 'yellow', 'green']}})

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

Anumber

Bmin

Cpercentile

Dmax

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'min' instead of 'number' which does not allow specifying a value.

Confusing 'percentile' with 'number'.

Setting minpoint type to 'number' allows specifying an exact numeric value for the minimum color scale point.

3fill in blank

hard

Fix the error in the color scale code by choosing the correct color format for the maxpoint color.

Google Sheets

ApplyConditionalFormat(range, {colorScale: {minpoint: {type: 'min'}, midpoint: {type: 'percentile', value: 50}, maxpoint: {type: 'max'}, colors: ['red', 'yellow', [1]]}})

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

Argb(0,255,0)

Bgreen

C#00FF00

Dgreenish

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-standard color names like 'greenish'.

Using color names that may not be recognized in Google Sheets.

Google Sheets color scales accept hex color codes like '#00FF00' for green. Named colors like 'green' may not always work.

4fill in blank

hard

Fill both blanks to create a 2-color scale from blue to white.

Google Sheets

ApplyConditionalFormat(range, {colorScale: {minpoint: {type: [1], maxpoint: {type: [2], colors: ['blue', 'white']}})

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

Amin

Bmax

Cnumber

Dpercentile

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'number' or 'percentile' without specifying values.

Swapping min and max types.

For a 2-color scale, minpoint type is 'min' and maxpoint type is 'max' to cover the full range.

5fill in blank

hard

Fill all three blanks to create a 3-color scale with min as 0, midpoint at 50 percentile, and max as 100.

Google Sheets

ApplyConditionalFormat(range, {colorScale: {minpoint: {type: [1], value: 0}, midpoint: {type: [2], value: 50}, maxpoint: {type: [3], value: 100}, colors: ['red', 'yellow', 'green']}})

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

Anumber

Bpercentile

Dmax

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'max' type for maxpoint with a value specified.

Using 'number' type for midpoint instead of 'percentile'.

Minpoint and maxpoint use 'number' type with values 0 and 100. Midpoint uses 'percentile' type with value 50.