Locked lesson.
About this lesson
Apply Color scales to a dataset to visually represent the relative values in a range of cells using colors.
Exercise files
Download this lesson’s related exercise files.
6.01 heat-maps-color-scales - Exercise.docx97.4 KB 6.01 heat-maps-color-scales - Exercise solution.docx
5.2 MB Exercise - Heat Maps.xlsx
10.1 KB Exercise - Heat Maps - Solution.xlsx
10.2 KB Workbook - Heat Maps.xlsx
10.2 KB Workbook - Heat Maps - Complete.xlsx
10.4 KB
Quick reference
Heat Maps: Color Scales
Apply Color Scales to data to assign different colors to cells depending on the value.
When to use
We use Color Scales whenever we want to represent values in cells using color. This helps us identify key trends and outliers.
Instructions
Color scales in Excel are a type of conditional formatting that visually represents the relative values in a range of cells using colors. They help users quickly interpret data by assigning different colors to cells based on their values, allowing for easy identification of trends, patterns, and outliers in data sets.
Apply Color Scales
- Select the data.
- From the Home tab, in the Styles group, click Conditional Formatting.
- Choose Color Scales.
We have several options. Some color scales are 3-color and some are 2-color. The first color listed is how the highest value will be shaded and the last color listed is how the lowest value will be shaded.
- Select the Red-Yellow-Green Color Scale.
Edit Color Scales
Color Scales are essentially just a conditional formatting rule and can be edited.
- Click in a cell where the color scale is applied.
- From the Home tab, in the Styles group, click Conditional Formatting.
- Click Manage Rules.
- Select the rule and click Edit Rule.
From here, we can change the colors and the scale if required.
Login to downloadSorry, we don’t have a transcript for this lesson yet.
Lesson notes are only available for subscribers.