• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Add Color Scales in Excel

July 23, 2021 by Andrew Childress
How to add color scales in Excel

When you’re working with data in Microsoft Excel, it’s often useful to apply simple color codes. Here's how to add Color Scales in Microsoft Excel.

When you’re working with data in Microsoft Excel, it’s often useful to apply simple color codes. At a glance, this helps you identify values on a relative basis: small, large, and more. Fortunately, this is easy to do in Excel, and doesn’t require any manual analysis. Let’s learn how to add Color Scales in Microsoft Excel.

How to Add Color Scales in Excel

Imagine that you’re working with a list of numbers, ranging between 0 and 100. You want to be able to quickly visually identify large, small, and neutral values. Of course, this could be done manually. Or, you could sort the data from largest to smallest. But for data in random order, it’s a great idea to color-code the values using the Color Scales feature in Excel.

To get started, click and drag your cursor to select the range of values. In this example, you’ll find them in cells D1:D6. With the range selected, go to the Home tab. You’ll find this on Excel’s ribbon, where it’s the default display option.

Color scales in Excel

Click on the Conditional Formatting dropdown button, which you’ll see on the right side of the Home tab. A variety of options will display, grouped into categories. The feature you want lies in the Color Scales section. Hover over it with your cursor to display a gallery of design options.

For example, the first choice is the Green-Yellow-Red Color Scale. This highlights higher values in green, lower values in red, and neutral values in yellow. Conversely, the Red-Yellow-Green Color Scale highlights high values in red, low in green, and so forth. The key is to understand your data and how best to format it.

Add color scales in Excel

When you’ve chosen a Color Scale option, simply click on its thumbnail. Excel will apply the chosen formatting.

How to add color scales in Excel

As you can see, Color Scales are a great way to add visual aids to any Excel spreadsheet.

Category: Excel TutorialsTag: Excel, How To, Instructions, tutorials

About Andrew Childress

Previous Post: « Text effects in Excel Text Effects in Excel
Next Post: Paste Special Values in Excel paste special values Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top