What is color scale mid in Google Sheets?

When to use it

Use formatting when a dashboard, report, or handoff sheet must be scannable without changing underlying values.

When to skip it

Skip heavy formatting on working tabs teammates still edit; keep decoration on views or presentation tabs.

Better Sheets resources

Related Tutorials

Watch how Color scale mid works

Watch more tutorials
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with...
Whitening Google Sheet Prank

Whitening Google Sheet Prank

Drive your office crazy by setting a trigger to lighten the text and bac...
DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Create dark mode with Conditional Formatting.
Ali Abdaal's Google Sheet | Year at a Glance

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step thro...
Study Better With Google Sheets

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.
Dark Mode / Better Font Color

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, do...

Related blog posts

Guides that explain Color scale mid in more depth.

Browse the blog

Related terms

Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.