New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Formatting›Apply a color scale

Google Sheets · Verified tutorial

Apply a color scale in Google Sheets

Apply a color scale conditional-formatting rule to B2:B6. Use any of Google Sheets' built-in color scales and do not change the values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Apply a color scale conditional-formatting rule to B2:B6. Use any of Google Sheets' built-in color scales and do not change the values.

Step-by-step

1

Select the targetApply a color scale conditional-formatting rule to B2:B6.

2

Apply the changeUse any of Google Sheets' built-in color scales and.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A gradient color-scale rule covers B2:B6.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select B2:B6 and repeat the final action. A gradient color-scale rule covers B2:B6.

Example spreadsheet data

This is the clean fixture used for the verified run.

Rep	Sales
Anna	1250
Ben	980
Cara	1730
Dev	1110
Eva	1480

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Apply a color scale conditional-formatting rule to B2:B6.
Apply the change. Use any of Google Sheets' built-in color scales and.
A gradient color-scale rule covers B2:B6.